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.
| Author |
Topic |
|
bgreenaway
Starting Member
4 Posts |
 Posted - 2007-12-12 : 13:25:33
|
| I am currently running a small SQL Server 2000 database called TOOLDATA on a very old server (SERVER1) which I wish to scrap and want to transfer it to another server (SERVER2) which is already running SQL Server 2000. The target server already has a copy of the TOOLDATA database but it is not used and is very out of date.Can someone provide or point me to an idiot-proof procedure on transferring the entire database from SERVER1 to SERVER2, retaining the same same database name (TOOLDATA) but overwriting the out of date version on the target server?Any help greatly appreciated. |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-12-12 : 15:27:01
|
| Backup the database on the source server and restore it on the target server.CODO ERGO SUM |
 |
|
|
bgreenaway
Starting Member
4 Posts |
Posted - 2007-12-12 : 17:56:55
|
| I did try that but I noticed that the tables in the source database did not transfer across to the target database. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-12-12 : 17:58:57
|
quote:
Originally posted by bgreenaway
I did try that but I noticed that the tables in the source database did not transfer across to the target database.
You didn't use BACKUP/RESTORE then.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-12-12 : 18:13:09
|
quote:
Originally posted by bgreenaway
I did try that but I noticed that the tables in the source database did not transfer across to the target database.
I really hate when that happens.  CODO ERGO SUM |
|
|
|
bgreenaway
Starting Member
4 Posts |
Posted - 2007-12-12 : 18:14:45
|
| Must have done something wrong because I did a backup and restore again and it seemed to go across fine. |
|
|
|
justmike2
Starting Member
1 Post |
Posted - 2008-01-02 : 12:58:11
|
| If you want to move multiple databases from one server to another, would you use the same backup/restore procedure for each individual database. That is what I did and it worked, but I kept thinking there has to be an easier way. thanksmike |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-02 : 23:25:44
|
| That's the sql way. Or you can stop sql on source server, copy all db files to target server then attach them. |
|
|
|
|
|
|
Moving databases from one server to another?