Moving a Database on SQL 7.0 or 2000

Always plan ahead

Test to make sure there aren't any hidden updates you'll need to do with the database in a new location.  Also test how long it will take to move the files and make sure there is enough space on the appropriate drives in the new location.

Q224071 INF: Moving SQL Server 7.0 Databases to a New Location
Q221465 INF: Using the WITH MOVE Option with the RESTORE Statement 
Q274188 PRB: "Troubleshooting Orphaned Users" Topic in BOL Incomplete
Q168001 PRB: User Logon and/or Permission Errors After Restoring Dump
Q246133 INF: Transfer Logins, Passwords Between SQL Server 7.0 and 2000
Q298758 PRB: Using Auto_Fix w/sp_change_users_login Leaves Vulnerability
Q274463 INF: Understanding and Troubleshooting the Copy Database Wizard

Back to Top

SQL Server Directory

How to Troubleshoot a Performance Problem 
Troubleshooting Blocking 
How to Move a Database 
Get the Latest Service Pack 
Misc. Tips and Tools 
SQL Server Knowledge Base Articles 
Common SQL Server Answers
SQL Server and Related Links

Back to Top
Main SQL Server Page