SQL Server - Backups

Maintenance Plan Cleanup Tasks

Friday, October 19, 2007

My observations suggest that you can only add a maintenance cleanup task (to delete expired backups) from the machine on which SQL Server resides. When I run the maintenance plan wizard from SSMS on my own machine, I don't get that option.

Once you successfully add a maintenance cleanup task, how do you get it to delete .bak, .dif and .trn files all in the same task? Leaving the extension box blank doesn't result in anything getting deleted. The secret is to enter * as the extension. The period before the extension should be omitted.

Labels: SQL Server, SQL Server - Backups, SQL Server - SSMS

Permalink

Maintenance Plan Cleanup Tasks

Links

Buy My Art

Labels

Recent Posts

Archives

Navigation

		Maintenance Plan Cleanup Tasks Friday, October 19, 2007 My observations suggest that you can only add a maintenance cleanup task (to delete expired backups) from the machine on which SQL Server resides. When I run the maintenance plan wizard from SSMS on my own machine, I don't get that option. Once you successfully add a maintenance cleanup task, how do you get it to delete .bak, .dif and .trn files all in the same task? Leaving the extension box blank doesn't result in anything getting deleted. The secret is to enter * as the extension. The period before the extension should be omitted. Labels: SQL Server, SQL Server - Backups, SQL Server - SSMS Permalink Links
	Buy My Art Original glass and gemstone jewelry and glass housewares at Jellybug Artworks! Labels Access ADO Art - Glass - Fusing - Ideas Art - Glass - Fusing Art Food Art ASP ASP.NET Beasts Excel Tricks Freecycle Haiku Hair Color Home Wares Internet Jewelry Kinetics Maine Outlook Tricks Recipe of the Week Song Stylings of Stephen Foster SQL Server - Backups SQL Server - Diagnostics SQL Server - Scripts SQL Server - SSMS SQL Server 2008 SQL Server Things to Do - Baltimore Titter To the Tune of Uncategorizable Silliness Web Applications - Javascript Web Applications Writings Recent Posts Coral Rings Jewelry Set Turquoise, Tigereye and Pearl Rope Nectarines and Cream Bracelet and Earring Set Rock Garden Symphony Dichroic Agate Necklace Nectarines and Cream Necklace Byzantine Turquoise Bracelet Blueberry Cream Bracelet Wild Rice Salad Flurry of Inspiration Archives January 1997 April 2001 June 2002 November 2002 January 2004 August 2004 November 2004 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 November 2005 May 2006 June 2006 July 2006 September 2006 February 2007 March 2007 May 2007 August 2007 October 2007 November 2007 January 2008 February 2008 March 2008 April 2008 May 2008 June 2008 July 2008 Navigation Home Art Photos Comics Recipes Hair
		Blogger Template by Gecko & Fly, modified by yours truly.