Results 1 to 4 of 4
  1. #1
    Join Date
    May 2003
    Location
    UK
    Posts
    220

    Angry Unanswered: Backup Options - low disk space

    Howdy,

    We have very a tight limit on disk space for backups.

    We have a 3 GB db that we do full a weekly full backup on, followed by hourly tran log backups for the rest of the week - this adds up to a LOT of disk space usage ( we cant do differential backups due to space limitations, as diffs are almost 3 GB in size... ).
    As disk space is limited, we can only keep a weeks worth of backups on the disk, and previous weeks get backed up onto tape. No big deal there.....

    So, when weekly full backup occurs, the only way to recover the previous weeks data is to restore previous full backup & allpy the required number of tran logs.

    Is there another way to do backups perhaps using file backups , so we dont have to go all the way back to the previous weeks backups?

    Thanks in advance,

    SG.

  2. #2
    Join Date
    Oct 2001
    Location
    Naples, FL
    Posts
    273
    Do you have a tape device on the machine? If so you could copy the backup off every night and run a full backup every night....if this is an important server, buy more disks!! I bought an external 80gb drive for $90, I would push back and have the company buy more space.

    HTH
    ---------------
    Ray Higdon MCSE, MCDBA, CCNA

  3. #3
    Join Date
    May 2003
    Location
    UK
    Posts
    220
    Hi,

    Thanks - I have suggested to the clients the disk space option is the best way of going, I just wanted someone else to say it too. I figure its not worth the grief for skimping on disk space for the sake of operational integrity.

    Cheers

    SG

  4. #4
    Join Date
    Sep 2003
    Location
    India
    Posts
    3
    Hi,
    If you haven't yet bought hard disk, you could do this. You could schedule the full backups daily and 'overwrite the existing media' instead of appending. Also you can delete the transactional log after the successful backup at the end of the day.
    You could continue with the weekly tape backups too. If you need to restore, you need to the full with no recovery and the tran log for just the previous day. Ofcourse if the restoration is beyond a days time, you will need to use the tape, previous days full backup and transaction logs.

    Hope this help you.

    Regards,

Posting Permissions

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