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
1. Migrating an SQL Server 7.0 database to an SQL Server 2000
Hello,
Does anybody know if there is a trick to be able to migrate a database from
an SQL Server 7.0 to an SQL Server 2000 ?
Thanks,
Pierre
3. Migrating from SQL Server 2000 to SQL Server 7
5. Migrate DTS from SQL Server 7 to SQL Server 2000
7. Downgrade / Migrate - SQL SERVER 2000 - SQL SERVER 7.0
9. Migrating from SQL Server 7.0 to SQL Server 2000
10. Migrating from SQL Server 7 to SQL Server 2000
11. Old ODBC drivers when connecting to SQL server 2000 from Developer 2000 apps
12. Migrating queries in Access 2000 to SQL Server 2000
13. ANNOUNCEMENT: New SQL Server security tool - SQL Server 2000 Scan Tool