Database restore job failing
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?
May 13th, 2010 12:05am

Hi, What's the restore tool are you using? Is it Windows Backup Utility(NTbackup)?
Free Windows Admin Tool Kit Click here and download it now
May 13th, 2010 1:35pm

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
May 13th, 2010 5:38pm

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.
Free Windows Admin Tool Kit Click here and download it now
May 14th, 2010 5:48am

You may also want to post in the Technet SQL forums as well: http://social.technet.microsoft.com/Forums/en/category/sqlserver
May 14th, 2010 5:58am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics