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