MIS Systems Thread, SIMS Tidy Backups - SQL 2008 - Autumn release in Technical; Hahah! It's test data on my system so its no big deal that it's been deleted.
I did try DAYS:1 ...
10th February 2011, 11:53 AM #46
Hahah! It's test data on my system so its no big deal that it's been deleted.
I did try DAYS:1 and PRESERVER:4 after and it still keeps all the old backups. I'll try just Preserve...
10th February 2011, 11:44 PM #47
preserve should be the min number of backups (of each database) that it keeps. I'm going to replace it with /min i think in the next release.
So for example, you backup everyday, you have it set to delete backups over 5 days, but for some reason it stops, 2 weeks later, you have no backups, unless the preserve option has been set in which case, you have at least that number of backups you've defined.
Thanks to matt40k from:
Rawns (11th February 2011)
11th February 2011, 09:04 AM #48
I see, so you can actually run the script with just the /DAYS:x and /ZIP command without preserve?
The only issue is that without adding the /PRESERVER parameter, the BAK file gets deleted before it's compressed.
11th February 2011, 09:33 AM #49
That's because it's older then the days set. Pointless compressing it then deleting it.
11th February 2011, 01:12 PM #50
How can it be older then 5 days if it's only been created?
By matt40k in forum MIS Systems
Last Post: 28th September 2010, 09:06 PM
By thesthelensman in forum MIS Systems
Last Post: 13th April 2010, 02:16 PM
By pete in forum MIS Systems
Last Post: 26th December 2009, 02:34 PM
By localzuk in forum MIS Systems
Last Post: 1st December 2009, 03:37 PM
By tech_guy in forum MIS Systems
Last Post: 7th January 2008, 01:58 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)