What are the challenges you face when working across database platforms? Take the survey
Options

Restore Job Fails

kedwardskedwards Posts: 10
edited January 17, 2008 8:29AM in SQL Backup Previous Versions
Hello,
We setup a job to do a nightly refresh of a training database from a SQL Backup v5 file. The first step of the job we disconnect all users then use the restore code like below. After about 22 minutes SQL server 2005 reports the job as successful, but it leaves the database in a restoring state. If I look at it through the SQL Backup console it does show it failed. Has anybody else seen this behavior?

master..sqlbackup N'-SQL "RESTORE DATABASE [TrainingDatabase]
FROM DISK = ''\\TestServer\D$\FULL_TrainingDatabase_20080114_212037.sqb''
WITH RECOVERY, REPLACE"'

Thanks,
Keith
Sign In or Register to comment.