I have a database with a scheduled backup on a primary that runs correctly. I'm copying the backup file to another machine, and restoring the backup to create a functionally identical database on the secondary server. I can initiate a manual restore task on the secondary server successfully. However, if I attempt to run the restore as a job it fails with the error message 'cannot process the data base because it is in use by this session'. The only step in the job is the restore script. I'm creating it from the 'script action to job' drop down selection in the Restore Task window. the job creates successfully. Again, a manual restore works, but when run as a job it fails. The script is correct, since I can run it from a command prompt successfully. Any ideas?

Hi, What's the restore tool are you using? Is it Windows Backup Utility(NTbackup)?

I'm running it from the task utility in mssql. I'm trying to restore the database, not the back-up file. the back-up file is intact and works if I restore manually from the task utility, but fails if I attempt to restore from a job. Restoring the file from the windows backup task isn't the same as restoring the database in mssql

Hi, This forum is for the topics relating to exchange. If the problem happens in MSSQL, I recommend you post this issue in MSSQL support forum.

You may also want to post in the Technet SQL forums as well: http://social.technet.microsoft.com/Forums/en/category/sqlserver