Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Site Related Forums
 Article Discussion
 Article: HOW TO: Move Databases Between Computers that are Running SQL Server (Q314546)

Author  Topic 

Ask SQLTeam Question

0 Posts

Posted - 2002-06-10 : 11:48:24
This step-by-step article describes how to move SQL Server user databases and most common SQL Server components between computers that are running SQL Server.

The steps described in this article assume that you will not move the master , model , tempdb , or msdb system databases. The steps provide different options for you to transfer logins and most common components contained in the master and msdb databases. For more information about moving system databases, see the Microsoft Knowledge Base articles listed in the "Step 1: How to Move User Databases" section of this article. Additionally, if you transfer the system databases, do not follow "Step 2: How to Transfer Logins and Passwords" through "Step 5: How to Move DTS Packages".

Article Link.

Posting Yak Master

206 Posts

Posted - 2002-11-08 : 12:30:30
The article link is dead.

Seattle, WA
Go to Top of Page

Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2002-11-09 : 12:11:10

The article link is dead.

Seattle, WA


Creating tomorrow's legacy systems today.
One crisis at a time.
Go to Top of Page

Starting Member

23 Posts

Posted - 2003-06-24 : 16:51:43
You can still get at it here:

No trees were killed in posting this message. However, a large number of electrons were seriously inconvenienced!
Go to Top of Page

- Advertisement -