Migrate from Old SQL 2000 server to a New SQL 2000 server
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
