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


Wed, 27 Oct 2004 03:43:57 GMT
 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



Wed, 27 Oct 2004 03:49:27 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Migrating an SQL Server 7.0 database to an SQL Server 2000

2. Migrating from SQL Server 2000 to SQL Server 7

3. Migrate DTS from SQL Server 7 to SQL Server 2000

4. Downgrade / Migrate - SQL SERVER 2000 - SQL SERVER 7.0

5. Migrating from SQL Server 7.0 to SQL Server 2000

6. Migrating from SQL Server 7 to SQL Server 2000

7. Old ODBC drivers when connecting to SQL server 2000 from Developer 2000 apps

8. Migrating queries in Access 2000 to SQL Server 2000

9. ANNOUNCEMENT: New SQL Server security tool - SQL Server 2000 Scan Tool

10. Connecting to a Sql Server 2000 SP3 from a Sql Server 2000 SP2

11. Support WebCast: Microsoft SQL Server 2000: Reading Execution Plans in SQL Server 2000

12. SQL Server 2000, SQL mail and Exchange Server 2000


 
Powered by phpBB® Forum Software