Restore Job Fails
kedwards
Posts: 10
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
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
