HPE Community
Windows Server 2003
1832834 Members
2846 Online
110047 Solutions
New Discussion

Maintanence plan under MSSQL 2005 doesn't work as expected

 
Vitaly Karasik_1
Honored Contributor

‎06-10-2008 12:20 AM

‎06-10-2008 12:20 AM

Maintanence plan under MSSQL 2005 doesn't work as expected

I use MSSQL 2005 and created a maintanence plan which included backup and cleanup tasks.
Backup task works well - it creates backup files daily.
But cleanup task, which should delete .bak files older when one week, doesn't work.
Logs and history don't shown something relevant.

any ideas?
0 Kudos
1 REPLY 1
James ~ Happy Dude
Honored Contributor

‎06-11-2008 03:39 AM

‎06-11-2008 03:39 AM

Re: Maintanence plan under MSSQL 2005 doesn't work as expected

Hello Vitaly,
A cumulative update is available for SP2(I guess you are running SP2).
Refer:
http://support.microsoft.com/kb/938085

Hope this Helps.

Regards,
0 Kudos
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.