What are the challenges you face when working across database platforms? Take the survey
Options

Readonly to Operational

vad2319vad2319 Posts: 40
edited December 26, 2007 3:58PM in SQL Backup Previous Versions
I have used Sql Backup's logshipping feature to transfer data from the sql server in our office to a DR Server at remote location. The database at remote site is currently in Read-only mode. I would like to test if the remote sql server database can be made operational.

I tried using:

"RESTORE DATABASE checklog2 WITH RECOVERY "

but it did not work. It gave the following error message.

"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.
"
No users are currently logged onto the remote sql server. not sure why its giving this particular error. Incase if I have to kill some processes prior to issuing the "restore database" command, please let me know some sql code about that as well.

Please advise.

Thanking you in advance.

Sincerely,
Paul

Comments

Sign In or Register to comment.