+ Post New Thread
Results 1 to 1 of 1
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 ...
  1. #1
    ICTNUT's Avatar
    Join Date
    Jul 2005
    Location
    Hereford
    Posts
    1,419
    Thank Post
    196
    Thanked 249 Times in 122 Posts
    Rep Power
    63

    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

    [edit]

    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.

    [/edit]
    Last edited by ICTNUT; 7th July 2008 at 01:11 PM. Reason: Found Solution



SHARE:
+ Post New Thread

Similar Threads

  1. sims.net sql server 2005
    By itgeek in forum MIS Systems
    Replies: 2
    Last Post: 14th March 2008, 07:02 PM
  2. SIMS Backups with SQL 2005
    By WithoutMotive in forum MIS Systems
    Replies: 5
    Last Post: 17th January 2008, 10:55 AM
  3. Not enough space for SQL server 2005 install
    By zag in forum MIS Systems
    Replies: 4
    Last Post: 10th October 2007, 09:02 AM
  4. Microsoft Virtual Server 2005 R2
    By FN-GM in forum Windows
    Replies: 2
    Last Post: 29th September 2007, 11:42 PM
  5. Virtual Server 2005 R2 kills server network connection
    By ajbritton in forum Thin Client and Virtual Machines
    Replies: 0
    Last Post: 31st August 2006, 07:19 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •