Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Duplicating Database from one server to another

Status
Not open for further replies.

tkatlas

MIS
Apr 24, 2000
8
US
I am trying to duplicate a production server to a test server and would normally just restore the user created database, say MY_DATABASE.&nbsp;&nbsp;Sometime when I do this I run into problems with user id's because the logins weren't the same.&nbsp;&nbsp;I tried restoring the master database, but ran into problems.&nbsp;&nbsp;First it had to be in single user mode which i did&nbsp;&nbsp;with sqlservr -m command.<br>Next, I tried restoring the Master database from a file and it said I needed to drop the database.&nbsp;&nbsp;Now, how do you drop the master database and be able to restore it.&nbsp;&nbsp;Any help would be greatly appreciated.<br>Thanks,
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top