General information
Forum:
Microsoft SQL Server
Title:
Auto Restore Script
Dear All,
I have created a Autorestore Job with the following script
RESTORE DATABASE WMS_UPDATE from DISK='E:\WMS_UPDATE_DAILY' with REPLACE
this script run just fine in SQL QUERY Analyzer but when ever I try to use it on an scheduled JOB an error occured saying
"Exclusive Access could not be obtained because database is in use"
Can anyone give me idea on how can I correct my script so as I can use it to autorestore my database.
MSSQL 2000 on Win2K3 server. this is not an active database it is only a standby server in case the primary went down.
thanks.
VER
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only