Migrate from Old SQL 2000 server to a New SQL 2000 server

Migrate from Old SQL 2000 server to a New SQL 2000 server

Post by Rick Phillip » Sun, 12 May 2002 04:43:57



Is there any documentation out there to
Migrate from Old SQL 2000 server to a New SQL 2000 server
 
 
 

Migrate from Old SQL 2000 server to a New SQL 2000 server

Post by Keith Kratochvi » Sun, 12 May 2002 04:49:27


You can try this for starters:

Don't forget to move the sql users!
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q246133

move the data via backup and restore (my preferred method)
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q304692

sp_detach_db and sp_attach_db
http://support.microsoft.com/support/kb/articles/q224/0/71.asp

one more option -- the copy database wizard
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q274463

additionally, these KB articles might provide additional information:

Map SIDs after a restore:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q298897

PRB: User Logon and/or Permission Errors After Restoring Dump (Q168001)
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q168001

INF: How to Resolve Permission Issues When a Database is Moved Between SQL
Servers (Q240872)
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q240872

--
Keith, SQL Server MVP


Quote:> Is there any documentation out there to
> Migrate from Old SQL 2000 server to a New SQL 2000 server