Results 1 to 5 of 5
  1. #1
    Join Date
    May 2006
    Posts
    1

    Unanswered: DB Maintenance - Purging Old File feature

    Hi,

    I'm using SQL2K with SP4 2187. I have created a DB Maintenance wizard where the purging older than 1 day is set.

    However, this feature seems not to be working, even if I tried two ways. Delete the scheduled job and recreate it - not successful, 2nd) delete the Maintenance Plan, still not successful.

    Is this a bug or do I miss something here.

  2. #2
    Join Date
    Nov 2005
    Location
    Jersey
    Posts
    47
    Hi.

    I've had the same issue. But with mine sometimes it works and sometimes it doesn't. I did notice that if there isn't enough room on the drive it will not delete the previous files.
    What I did is create a job that deletes the backups everynight at 6pm. By 6pm the Enterprise backup has already taken the backups off of the server.
    It's very simple. Create a batch file that does a del *.bak and call the batch file from the job step.

    I hope this helps.

  3. #3
    Join Date
    Jan 2006
    Location
    USA
    Posts
    115
    Many times concerning automation system for deleting data, manual data deleting is good. In any case if something goes wrong you will be loss everything....

  4. #4
    Join Date
    Feb 2005
    Posts
    78
    We found that if you have a data base using the SIMPLE model but still do a transaction log backup then this feature may not work for ANY of the databases in the same maintenance plan. The number of backup files just grew and grew.

  5. #5
    Join Date
    Nov 2005
    Location
    Jersey
    Posts
    47
    I found that same issue with the transaction log bkup. Microsoft ...
    If you have the time everyday and remember to do it, I guess a manual bkup is better.
    On my end, we update our databases from our old cobol dos system with txt files so if we loose a day it's not a big deal. We can just reload the data.
    The other option would be to talk to who ever is doing the enterprise bkups off of the server. Maybe they can move instead of copy the files.

Posting Permissions

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