July 3, 2003 at 7:30 am
We have a production database that has a full backup performed every morning to the same device. The backup devices are stored on a RAID-5 disc array.
This database is also backedup every 1/2 hour as a transaction backup.
Would it be safer to do M/W/F, T/Thu/Sat and Sunday backup devices so that if any one backup file becomes corrupt, it would not affect the other full backups?
Any help would be greatly appreciated.
July 3, 2003 at 8:46 am
Good idea if you are using Backup device. We usually backup to the Disk to Tape
Shas3
July 3, 2003 at 5:15 pm
Shas3's "disk to tape" point is important. I can't emphasise enough the need to get those backups off the server and onto another medium or another (possibly remote) server.
It sounds at the moment like you risk losing everything if you lose your database server.
In regard to your backup strategy, instead of using backup devices, it may be worthwhile using backup cycling and cleanup facilities that are provide by maintenance plans, or by direct invocation of xp_sqlmaint. You could tell it to keep the 2 latest backups and clean up older ones.
Cheers,
- Mark
July 7, 2003 at 5:55 am
There is a separate process that performs a disc to tape copy of the .bak files. And the backups are on a separate raid controller, not on the actual database server.
I have looked into the maintenance plans and have suggested using that as an alternative for the very reasons you (mccork) have mentioned.
Thanks!
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply