Error Kickmaleerie

  • Subscribe to our RSS feed.
  • Twitter
  • StumbleUpon
  • Reddit
  • Facebook
  • Digg

Monday, July 11, 2011

SQL Server Maintenance Plan Cleanup not working

Posted on 7:18 AM by Unknown
Like many folk, I've recently been caught out by the bug in SQL Server 2008 Maintenance Plan Cleanup tasks apparently running OK but not actually deleting files and the backup volume filling up.

This is caused by the trailing slash '\' being omitted from the folder path and giving the file extension as .BAK (or .TRN) and not just BAK (or TRN) without the . (dot) when editing the subplan properties. Correct this and everything works OK. James Howard provides a slightly longer explanation in his blog on this iLinkssue.
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Posted in | No comments
Newer Post Older Post Home

0 comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Popular Posts

  • Find SQL Servers on your Network
    Very useful script.
  • IIS6 Known Extensions feature
    Yesterday I ran across this issue when a user of our IIS6 hosting service reported that their Authorware applications were giving timeouts...
  • ARPs and NIC Teaming
    Background: A NIC Team is known by a single MAC address to clients in the network. This MAC address is only used as the source MAC address...
  • aacPlus delivers 48Kbps stereo
    As a listener to the very excellent Groove Salad on the online station SomaFM you have got to be impressed with the CD quality 48K aacPlus...
  • Dell iDRAC6 Virtual Media Detached error
    See the solution to this error here: http://www.it-book.co.uk/771/error-attaching-iso-in-idrac-%E2%80%93-virtual-media-is-detached
  • SQL 2008 Reporting Services and SCCM 2007 R2
    The above provides a link to the SCCM Team blog explaining why you must have Reporting Services configured against the default instance of S...
  • SSI stuff
    Useful info on SSI date and time formats and examples of their use. Not forgettng the Apache tutorial
  • Not such a bargain then
    I don't know why but many of my middle class friends and colleagues have a penchant for shopping in Lidl and seem to get genuine joy - u...
  • High Availability in SQL Server 2005
    Had a technical architecture document recently from an external supplier proposing a mirrored SQL Server 2005 setup with the Principal as a ...
  • Warhol and Web 2
    As Warhol noted in 1968 " in the future everyone will be famous for 15 minutes ". Andy had the vision but we just lacked the mecha...

Categories

  • logs
  • sawmill
  • w3c

Blog Archive

  • ▼  2011 (9)
    • ►  October (1)
    • ►  August (2)
    • ▼  July (1)
      • SQL Server Maintenance Plan Cleanup not working
    • ►  June (2)
    • ►  May (2)
    • ►  April (1)
  • ►  2010 (8)
    • ►  December (1)
    • ►  November (1)
    • ►  August (1)
    • ►  June (1)
    • ►  April (1)
    • ►  March (1)
    • ►  January (2)
  • ►  2009 (5)
    • ►  July (1)
    • ►  May (2)
    • ►  April (1)
    • ►  January (1)
  • ►  2008 (5)
    • ►  December (1)
    • ►  September (1)
    • ►  August (1)
    • ►  July (1)
    • ►  February (1)
  • ►  2007 (11)
    • ►  November (1)
    • ►  October (1)
    • ►  August (1)
    • ►  May (2)
    • ►  April (2)
    • ►  March (2)
    • ►  February (1)
    • ►  January (1)
  • ►  2006 (15)
    • ►  December (1)
    • ►  November (3)
    • ►  October (1)
    • ►  September (2)
    • ►  August (1)
    • ►  July (4)
    • ►  June (1)
    • ►  March (2)
  • ►  2005 (25)
    • ►  October (1)
    • ►  September (2)
    • ►  August (9)
    • ►  July (1)
    • ►  May (1)
    • ►  April (2)
    • ►  March (1)
    • ►  February (3)
    • ►  January (5)
  • ►  2004 (16)
    • ►  December (6)
    • ►  November (10)
Powered by Blogger.

About Me

Unknown
View my complete profile