SQL Server database backup and restore in different servers using DTS
SQL Server database backup and restore in a different server using DTS is explained by expert Greg Robidoux.
I need to restore a database in a different server than it was backed up in. I need to do this three times each day, so I made a DTS package. When I try to restore, the destination server fails because the database is not the same in the source server. How can I back up and restore a database in different servers using DTS?
You will need to specify the MOVE option with the RESTORE DATABASE command. Take a look at the tip
Restoring a database from another SQL Server, to get further information on restoring the database as well as linking users and logins.
Do you have comments on this Ask the Expert Q&A? Let us know.
Free membership is required to view this page
Become a member now to view all TechTarget content freely.
Sign in for existing membersBy submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy Policy
Do you have comments on this Ask the Expert Q&A? Let us know.
This was first published in
August 2005
Dig deeper on SQL Server Backup and Recovery
Pro+
Features
Enjoy the benefits of Pro+ membership, learn more and join.
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.
Meet all of our SQL Server experts
View all SQL Server questions and answers
0 comments
Oldest Newest