July 10, 2008 at 10:12 am
HI Everyone
I did created a backup plan for Database, It work fine for creating backup files but not deleting older back up files (.bak) even though i am using Maintenace Cleanup Task after backup.
Moreover when I did check from events Viewer, I have some errors of
SQLISPackage Errors ID 12291.
Can Anyone please help me,
Thanks
July 10, 2008 at 4:03 pm
A few things you might try...
--Check that the backup file location and the path in the cleanup task are identical (not a mapped drive in one and UNC in another, for example). If "create subdirectory for each database" is checked for the backup, then "Include first-level-subfolders" will need to be checked in the cleanup step.
--Verify that the version of SSMS used to create the maintenance plan is the same as the version of the server. It think that SP2 had different values for the deletion "interval", so if you are using SP2 tools against an RTM database, or a straight SP2 tool against a patched SP2 server, or some other mis-matched combination, that interval might be messed up. Maybe try creating the maintenance plan directly on the server.
--Run the maintenance plan manually (not from a scheduled job), see if the same errors occur
Hope this helps!
Chad
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply