Windows Thread, SQL Server 2005 Backups Problem in Technical; Does anyone n=know how to auto delete old backups?
I have a maintenance plan that backups our SIMS DB every ...
7th July 2008, 09:53 AM #1
SQL Server 2005 Backups Problem
Does anyone n=know how to auto delete old backups?
I have a maintenance plan that backups our SIMS DB every hour between 8am and 5pm as well as daily but I only want to keep 2 days of hourly and 5 days of daily but no matter what I try I just can't get them to auto delete.
Any ideas anyone
I have figured it out !
Where it saya enter file extension you need to put the file extesion in without the the dot i.e. bak and not .bak
Funny as it will accept both an nowhere does it tell you not to put the dot in.
Last edited by ICTNUT; 7th July 2008 at 12:11 PM.
Reason: Found Solution
By itgeek in forum MIS Systems
Last Post: 14th March 2008, 06:02 PM
By WithoutMotive in forum MIS Systems
Last Post: 17th January 2008, 09:55 AM
By zag in forum MIS Systems
Last Post: 10th October 2007, 08:02 AM
By FN-GM in forum Windows
Last Post: 29th September 2007, 10:42 PM
By ajbritton in forum Thin Client and Virtual Machines
Last Post: 31st August 2006, 06:19 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)