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 |
|
pras2007
Posting Yak Master
216 Posts |
 Posted - 2009-04-03 : 18:27:18
|
| Hello All,I want to copy a database from one server to a different server by the way of backup and restore. Below are questions that I have:How can I copy a database from one server and restore it in another server that already has an old copy of that database? What would be the best way to move the backup database from the first server to the second server?Once that backup file is in the second server, then I can be able to restore that database?Please advice. Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
pras2007
Posting Yak Master
216 Posts |
Posted - 2009-04-06 : 00:51:03
|
| Thanks for the response. I Tried to restore the database, but is seems that I grab the wrong .bak file, now the database is stuck in restoring mode. Does anyone know how to stop the restore? Please help |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Backup and Restore