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 |
|
mike123
Master Smack Fu Yak Hacker
1462 Posts |
 Posted - 2002-04-26 : 23:29:17
|
| im moving a database across to a different server. What is the best way to do this? I keep getting errors using DTS -> Export then selecting "copy objects and data between sql servers"Is this the correct tool to use? I want to make sure all my SP's and database diagrams, etc are all copied over as well.Thanks again,MIke |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-04-27 : 01:22:54
|
| HiWhat errors are you getting ?Another way, if you have the same version of SQL Server on each machine, is to back up the database on one, and restore it on the other.Damian |
 |
|
|
VyasKN
SQL Server MVP & SQLTeam MVY
313 Posts |
Posted - 2002-04-27 : 08:15:37
|
| DTS is not the right tool for this. Use BACKUP/RESTORE. Backup the database on the source server. Restore from this backup file on the target server.If you don't mind some downtime on the source server, then you can even detach the databse using sp_detach_db, copy the database files across to the other server. Then attach the database back again to the source server using sp_attach_db. Attach the copied files to the new server using sp_attach_db.You can even restore 7.0 backups into SQL Server 2000. And attach 7.0 databases to 2000.Only problem is that, you can not restore 7.0 log files into 2000 db, in STANDBY mode.--HTH,VyasCheck out my SQL Server site @http://vyaskn.tripod.com |
|
|
|
|
|
|
best way to move a database