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

  • 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
  • more getting the SMS message
    Following my recent " getting the message - too late " post about my employer's evident inability to "get" SMS as a ...
  • Find SQL Servers on your Network
    Very useful script.
  • Java Service Wrapper
    Over the past few months I have been using the very excellent eXist XML database available under the GNU LGPL on a project to store and qu...
  • Changes, changes
    Having reached 60 in pretty decent shape I decided to retire and did so on the 29th July. There will be fewer technical issues blogged as I ...
  • 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...
  • beyond marks on paper
    Ted Nelson's concept of hypertext predates the web, so it was interesting to get a request this morning from an academic colleague to ...
  • been away a while
    Work and my starting an Open University course ( M358 ) have kept me away for a while. But I'm happy to report having stumbled across t...
  • SQL Server 2000 backuphistory quirk
    We came across this recently when we tried to delete a database and found that the server was churning away for hours at > 50% on each CP...
  • an idiot a day helps you ...
    I've spent one of those difficult weeks in which nothing goes according to plan and you also choose (big mistake) to attempt a rational ...

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