June 13, 2009 at 9:15 pm
Hi Guys,
i am restoring my database using this commnad
restore Database kiki from TAPE ='\customerdetails1\Tape0'
my system giving this error
exclusive access could not be obtained the database is in us
Restore database is terminating abnormally.
could you any body plz help really appreciate those guys.
Best Regards
June 13, 2009 at 9:35 pm
You have someone connected to the database, perhaps even you. You need to remove everyone from the database before you can restore.
June 13, 2009 at 9:44 pm
and you can remove all your connections(except yours) by this:
alter database yourdb
set single_user with rollback immediate
Just remember, this will force user connections to drop. all running queries will be rolled back.
June 13, 2009 at 10:14 pm
Hi steve/sp,
Thanks for your reply
i had put it into singleuser mode using alter db
after then i had restore with tape drive but giving this error
"Device error or device off-line"
Restore db is terminating abnormally.
Best Regards
🙂
June 13, 2009 at 10:16 pm
Hi Steve,
You have someone connected to the database, perhaps even you. You need to remove everyone from the database before you can restore.
I am new to ADMIN part how can we disconnected to db what are the connections could you plz.. some detailed...
Best Reagards
😛
June 13, 2009 at 10:20 pm
are you sure you typed the name of the backup file correctly?
Also, did you take the db backup directly on tape or did you backup ur db on disk and then moved to tape? In later case you may want to restore the backup file from tape to disk and then start restoring the db.
June 13, 2009 at 10:22 pm
the statment u ran 'with rollback imme...' would disconnect all users except you as u're also connected by the query window u typed that statement. Once u close that query window, your connection will also be dropped.
June 14, 2009 at 8:39 am
you want to run this restore while you are connected to the Master database, not the one you are restoring.
June 14, 2009 at 9:18 am
shiv (6/13/2009)
"Device error or device off-line"Restore db is terminating abnormally.
have you checked the tape drive
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 17, 2009 at 1:37 pm
Make sure you have full permissions on Tape More over its a error from database make sure you close all connections using activity monitor or sp_who/sp_who2
🙂
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply