+ Post New Thread
Page 4 of 4 FirstFirst 1234
Results 46 to 50 of 50
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 ...
  1. #46
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 489 Times in 375 Posts
    Rep Power
    0
    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...

  2. #47

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,406
    Thank Post
    368
    Thanked 639 Times in 521 Posts
    Rep Power
    158
    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.

  3. Thanks to matt40k from:

    Rawns (11th February 2011)

  4. #48
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 489 Times in 375 Posts
    Rep Power
    0
    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.

  5. #49

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,406
    Thank Post
    368
    Thanked 639 Times in 521 Posts
    Rep Power
    158
    That's because it's older then the days set. Pointless compressing it then deleting it.

  6. #50
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 489 Times in 375 Posts
    Rep Power
    0
    How can it be older then 5 days if it's only been created?

SHARE:
+ Post New Thread
Page 4 of 4 FirstFirst 1234

Similar Threads

  1. [SIMS] SIMS 2010 Autumn Pre-Release Note
    By matt40k in forum MIS Systems
    Replies: 8
    Last Post: 28th September 2010, 09:06 PM
  2. Move to SQL 2008 and backups
    By thesthelensman in forum MIS Systems
    Replies: 2
    Last Post: 13th April 2010, 02:16 PM
  3. SIMS Autumn 09 Release - Experiences?
    By pete in forum MIS Systems
    Replies: 35
    Last Post: 26th December 2009, 02:34 PM
  4. SIMS.net Autumn release - Options 5.7
    By localzuk in forum MIS Systems
    Replies: 0
    Last Post: 1st December 2009, 03:37 PM
  5. Error Doing Tidy Backups in Sims.Net
    By tech_guy in forum MIS Systems
    Replies: 0
    Last Post: 7th January 2008, 01:58 PM

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
  •