Hi,
We are testing SQL2008, and while doing a hourly backup of logs via sql serveragent/jobs to the disk in the same box as the sql , we get this message.
(The database is NOT in used by any one else - we are testing the backup routine )
The error is ..
Message
The job failed. The Job was invoked by Schedule 93 (hourly between 6am and 12am). The last step to run was step 1 (RTRData Log Backup). NOTE: Failed to notify 'nmc' via network popup.
and the detail is
Message
Executed as user: INTSTAGE\svcsql. Database 'RTRData' cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server errorlog for more information. [SQLSTATE 42000] (Error 926) BACKUP LOG is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
Note :
But if we run the sql job manually the jobs runs ok without any errors.
When we schedule it to run every hour, it fails and puts the database in suspect mode.
Thanks