July 1, 2009 at 9:53 am
I am having backup failure to my database. I am not sure why either.
EXECUTE master.dbo.xp_sqlmaint N'-PlanID 3A33DB99-EB66-4A30-BAA7-A170A05DB2E4 -WriteHistory -VrfyBackup -BkUpMedia DISK -BkUpDB -UseDefDir -DelBkUps 2DAYS -BkExt "BAK"'
Thats my sql that I run to backup my db and here are my error messages I get from Query Analyzer.
(5 row(s) affected)
Server: Msg 22029, Level 16, State 1, Line 0
sqlmaint.exe failed.
Any Help?:unsure:
July 1, 2009 at 10:04 am
Your directory structure may differ, but this is where I find my output files for the maintenance plans run on one of my servers:
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG
Look there and you should be able to figure out what the problem is with your backups.
July 2, 2009 at 4:46 am
I have also faced this issue many times , no exact solution obtained , but if u delete any one of the jobs like int or opt or backup created using same Maintenance plan, then this error pops , recreate the plan , better to create individual maintenance plan to Backup , integrity and optimization plans , also check the service pack level
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply