Results 1 to 3 of 3
  1. #1
    Senior Member GregE's Avatar
    Join Date
    May 2006
    Posts
    2,100
    Thanks
    9
    Thanked 17 Times in 16 Posts

    Default SQL Yearly Backup

    I've been asked to setup an SQL db backup that will occur every year at the end of the fiscal year, and it will only require retaining for 1 year from its backup date. So the simple thought was to bind it to a management class with a one year retainonly value and be done.

    BUT, then it occurred to me................since I am only running this backup once a year, the first backup does not go inactive until the next backup a full year later, so at that point the first backup has already been retained for a full year, meeting my requirements, and will now be on the expiration clock for an additional year and actually exist in backup storage for TWO years, unless I instead bind it to a short retainonly (7-10 days max), so that when the Year 2 backup occurs, the Year 1 backup inactivates and is gone a few days later, instead of remaining for an additional entire year.

    Is this a normal method of handling it? The only risk I see is that if a backup is run before the next schedule then we lose the previous end of year backup before the next end of year backup happens.

    Also been asked to setup a quarterly backup and only retain it for 90 days. Same situation as the yearly, more often.
    Last edited by GregE; 12-17-2012 at 10:47 PM.

  2. #2
    Senior Member Trident's Avatar
    Join Date
    Apr 2007
    Location
    Oslo, Norway
    Posts
    271
    Thanks
    2
    Thanked 19 Times in 19 Posts

    Default

    I make a seperate node for yearly backups (and monthly).
    -= Trident =-

  3. #3
    Senior Member GregE's Avatar
    Join Date
    May 2006
    Posts
    2,100
    Thanks
    9
    Thanked 17 Times in 16 Posts

    Default

    Yep that's what I'm doing.

Similar Threads

  1. yearly backup to tape?
    By oskie in forum Backup / Archive Discussion
    Replies: 3
    Last Post: 07-28-2008, 10:55 AM
  2. Daily backup and yearly archive
    By Jcage in forum Backup / Archive Discussion
    Replies: 2
    Last Post: 07-03-2008, 04:04 PM
  3. Ques on yearly backup.
    By vvragav in forum Backup / Archive Discussion
    Replies: 4
    Last Post: 03-03-2008, 12:47 AM
  4. Yearly Backup
    By Quake in forum Backup / Archive Discussion
    Replies: 14
    Last Post: 12-20-2007, 12:16 PM
  5. Replies: 2
    Last Post: 04-07-2003, 08:12 AM

Posting Permissions

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