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

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Migrate Database

Author  Topic 

Fatalsniper
Starting Member

45 Posts

Posted - 2005-06-04 : 11:45:15
Hi there,

I just wanted to know how migrate a running SQL Server Database, to a new computer, so it will be exactly the same but In a new computer.

Thanks in advance...

robvolk
Most Valuable Yak

15732 Posts

Posted - 2005-06-04 : 12:53:34
Probably the easiest way is to make a backup of the database and restore it onto the new computer. The BACKUP and RESTORE commands are documented in Books Online, if you get stuck you can post a follow up here.
Go to Top of Page
   

- Advertisement -