Readonly to Operational
vad2319
Posts: 40
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
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
http://msdn2.microsoft.com/en-us/library/aa238208.aspx
and resolved it.