Re: Server Migration
From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 08/18/04
- Next message: Tibor Karaszi: "Re: Best way to rename a server"
- Previous message: Julian: "Unkown Token Received From Sql Server"
- In reply to: Ed: "Server Migration"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 18 Aug 2004 22:19:48 +0200
One or more of below articles should help you understand issues with backup/restore:
Moving SQL Server Databases
http://www.support.microsoft.com/?id=224071
Moving Databases between Servers
http://www.support.microsoft.com/?id=314546
Using WITH MOVE in a Restore to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465
How To Transfer Logins and Passwords Between SQL Servers
http://www.support.microsoft.com/?id=246133
Mapping Logins & SIDs after a Restore
http://www.support.microsoft.com/?id=298897
Utility to map users to the correct login
http://www.dbmaint.com/SyncSqlLogins.asp
How to Resolve Permission Issues When a Database Is Moved Between SQL Servers
http://www.support.microsoft.com/?id=240872
User Logon and/or Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=168001
Disaster Recovery Articles for SQL Server
http://www.support.microsoft.com/?id=307775
-- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ "Ed" <Ed@discussions.microsoft.com> wrote in message news:4F57641A-3EFA-42A6-83A9-90349138CC4F@microsoft.com... > 1.The best way to do the server migration is through the backup and restore, > is that correct? if this is the case, do i need to restore the systems > databases first or user databases first. > 2. Since I already build the new SQL Server, and It contains the system > databases(Master, MSDB, Model) If I use Detach and Attach stored procedures > to do the databases migration, should I overwrite all the existing systems > databaes in the new server? Should I detach all the system databases in the > new server and overwrite all those databases with the Old server's systems > databases and Attach them back on the new server? > Thanks a lot, any suggestion is welcome > Ed
- Next message: Tibor Karaszi: "Re: Best way to rename a server"
- Previous message: Julian: "Unkown Token Received From Sql Server"
- In reply to: Ed: "Server Migration"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
