Hi All,
I am somewhat new to SQL Server, and I am having the following issue that I can't figure out.
I have a job that backs up three databases. I set up the job a few months ago. It was working just fine until about a month into my maternity leave when the third step started failing with the error message: Executed as user: DOMAIN\dbuser1. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.
I tried re-creating the third step using the other two steps as a template but the new one still fails.
Here are the details of each of the steps:
STEP 1
- backs up a large 50 GB database.
- Type: Transact-SQL script (T-SQL)
- Run as is blank
- Database: master
- Command: EXEC xp_sqlmaint ' -S sql002.rmi.local -D "SPProductionContent" -BkUpDB "\\server.domain.local\Backups\Weekly" -BkUpMedia DISK -DelBkUps 30days -Rpt "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Log\Backup.txt" -DelTxtRpt 4weeks -VrfyBackup'
STEP 2
- backs up a much smaller database
- Type: Transact-SQL script (T-SQL)
- Run as is blank
- Database: master
- Command: EXEC xp_sqlmaint ' -S sqlserver.domain.local -D "Database2" -BkUpDB "\\server.domain.local\Backups\Weekly" -BkUpMedia DISK -DelBkUps 30days -Rpt "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Log\Backup.txt" -DelTxtRpt 4weeks -VrfyBackup'
STEP 3
- backs up a small database
- Type: Transact-SQL script (T-SQL)
- Run as is blank
- Database: master
- Command: EXEC xp_sqlmaint ' -S sqlserver.domain.local -D "Database3" -BkUpDB "\\server.domain.local\Backups\Weekly" -BkUpMedia DISK -DelBkUps 30days -Rpt "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Log\Backup.txt" -DelTxtRpt 4weeks -VrfyBackup'
I can back up this database manually with no problems. There is plenty of space on the destination server.
I am not sure how to troubleshoot this further. Any suggestions would be appreciated.
BRL8