July 31, 2008 at 11:31 pm
I try to restore full and transaction log backup from device, the following conmmands, but backup taken successfully and could not restore the full backup on database.
backup database rilexedb to disk = 'c:\RILEXEDB.BAK' - work fine
Restore backup
---------------
restore database rilexedb from disk ='c:\RILEXEDB.BAK' with norecovery
the above restore command fail, error is
Server: Msg 3101, Level 16, State 2, 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.
August 1, 2008 at 12:38 am
You have to include the REPLACE qualifier to replace the existing database. Additionally, you may need to set the database into single_user to get exclusive access.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 1, 2008 at 12:40 am
kill / terminate all connections to your database being restored.
:-):cool:
August 1, 2008 at 1:05 am
thanks for reply
after restoring Database still keep on loading conditions,plz tell me what is actual issue?
August 1, 2008 at 1:19 am
have you refreshed your view in Enterprise manager?
:-):cool:
August 1, 2008 at 2:41 am
i refreshed sql server view and tried stop and strat sql server service, still showing loding conditions......
August 1, 2008 at 2:51 am
its because you restore the full backup with NORECOVERY option... do you have additional backup like transaction log backup to restore?
check the syntax of RESTORE DATABASE in BOL.
:-):cool:
August 1, 2008 at 2:53 am
Hi
How big is the db you are trying to restore. How long did you wait before restarting sql service?
"Keep Trying"
August 1, 2008 at 3:15 am
thanks for your valuable reply
Now restore was solve
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply