Backup plan for 3 servers (450GB) - SQL 2008, Active Directory on Win2k3, linux
Posted on 2009-05-07
We're reaching our limits on our current tape backup solution. While looking around, three consultants gave me different solutions and so I thought I'd come here for feedback.
Windows server 2008 running SQL 2008 (150GB of data) running a good to-file backup plan. Windows Server 2003 hosting Active Directory and right now doing all the file sharing (profiles, home directories, etc).
Linux servers doing flat-files backup to the windows server for backup.
I need 450GB of files backed up and archived in case of lost data, lost server and point-in-time recovery.
I also need to think about system recovery like system state so that if I lose a server I can get something comparable back up fairly quickly.
Option 1) Backup server with backup exec, agents and an Ultrium 3 or 4 tape drive to backup all files to disk image, then backup to tape. Pros: can easily do off-site backup/ if one of the servers die I still have the backup server to recover from / if backup server dies, not mission-critical. Cons: In the event of catastrophic failure, it can be tricky to restore everything from tapes.
Option 2) Disk-based appliance that handles all the backups. Pros: Fast, instant. Cons: off-site backup more expensive, limited by disk space so might limit my point-in-time recovery options.
Option 3) Virtualization. Pros: Portable. Cons: I don't have much hardware to setup as a test environment and probably require fine-tuning to get performance 100% (or even usable); Still need a file backup solution.
Maybe because it's what I"m used to, option 1 still makes the most sense to me.
Any other options? Discuss!