|
|
Posted by Trevor Best on 10/01/31 11:26
I have a maintenance plan on a client's site, there's only one database
in the plan and it's set to backup db and log, this job fails
consistently. The one step in the job contains this line:
EXECUTE master.dbo.xp_sqlmaint N'-PlanID
392B2334-6800-4655-A6C7-5414D9072505 -WriteHistory -VrfyBackup
-BkUpMedia DISK -BkUpDB "C:\Program Files\Microsoft SQL
Server\MSSQL\BACKUP\DailyBackups" -DelBkUps 4WEEKS -BkExt "BAK"'
Which fails if run in QA with the message:
Server: Msg 22029, Level 16, State 1, Line 0
sqlmaint.exe failed.
I've searched for this error and cannot find anything to help.
There's no "-S" in the path, it writes absolutely no history on the
plan. I set the plan to write history in the log directory on the
server, it wrote nothing to that directory.
The database doesn't get backed up but is able to be backed up manually
to the path specified in the plan. I also have a separate job with a
SQL backup statement in it that works OK so SQLAgent is working.
Navigation:
[Reply to this message]
|