May 17, 2011 at 12:32 pm
My maintenance plan appears to run but when I look at the detail is shows that the substep did not which produce the 22029 error.
Any ideal or help is appreciated, thanks.
My plan is as follow:
EXECUTE master.dbo.xp_sqlmaint N'-PlanID 4A146C17-0BBC-42B6-9135-48040F241AC5 -Rpt "D:\Program Files\Microsoft SQL Server\MSSQL\LOG\AAAA6.txt" -DelTxtRpt 1WEEKS -WriteHistory -VrfyBackup -BkUpOnlyIfClean -CkDB -BkUpMedia DISK -BkUpLog -UseDefDir -DelBkUps 1WEEKS -CrBkSubDir -BkExt "TRN"'
the output that was produce is:
NULL
Microsoft (R) SQLMaint Utility (Unicode), Version 8.00.2039
Copyright (C) Microsoft Corporation, 1995 - 1998 NULL
Logged on to SQL Server 'ABCDEF' as 'ACCESS\sa' (trusted) NULL
Starting maintenance plan 'BBBB' on 5/17/2011 2:13:43 PM NULL
[1] Database BBBB: Check Data and Index Linkage... NULL
NULL
** Execution Time: 0 hrs, 0 mins, 2 secs ** NULL
NULL
Backup can not be performed on database 'BBBB'. This sub task is ignored.
NULL
NULL
NULL
Deleting old text reports...
1 file(s) deleted.
NULL
NULL
End of maintenance plan 'BBBB' on 5/17/2011 2:13:45 PM
NULL
SQLMAINT.EXE Process Exit Code: 1 (Failed)
NULL
(27 row(s) affected)
Server: Msg 22029, Level 16, State 1, Line 0
sqlmaint.exe failed.
May 17, 2011 at 2:28 pm
Never mind I figure out what the problem is, the database was set to Simple and not Full.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply