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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

can't get the restore to work 1

Status
Not open for further replies.

phil22046

Programmer
Sep 12, 2001
154
US
I successfully added a backup device with the sp_addumpdevice command.

Next I tried to restore the S030 Database with this command:

restore database S030 from [S030diff] with replace

S030Diff is a backup of the S030 database from the production server. I am trying to restore to another server which is not available to anyone but me. And I get these errors:

Server: Msg 3101, Level 16, State 1, Line 1
Exclusive access could not be obtained because the database is in use.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
 
I had to reboot the server to get the problem solved of non-existant people being connected to my database.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top