Backup Disaster Recovery Best Practices

Ignoring all current establish backup procedures already in place, I'd like to know what the users of EE would say about how to back up the following:
Server #1: Exchange (50GB of Exchange Data, 85BG total used disk space) [Growth: low]
Server #2: SQL (110GB SQL Data, 140GB total used disk space) [Growth: low-moderate]
Server #4: SQL (45GB SQL Data, 55GB total used disk space) [Growth: moderate-high]
Server #5: File Server (210GB Data, 275Gb total used disk space) [Growth: low-moderate]
Server #6: Web Server (25GB Data) [Growth: low]

All servers are on gigabit and are running a mix of Server 2000/2003.

What to I buy and how do I backup all this data? The only requirement is that daily backups are made of each (though they don't need to be full backups) and that a backup of the previous day is always offsite (And able to be recovered independently ... so full backups need to be available along with differential/incrementals). Try to be as budget-conscious as possible.
LVL 20
DVation191Asked:
Who is Participating?
 
MidnightOneConnect With a Mentor Commented:
There's only a few disaster scenarios, thus:

[1] Site exists, server crashed
[2] Site exists but is unreachable (think:snowstorms, evacuations)
[3] Site exists, massive equipment losses (think: switch fails, virus runs rampant)
[4] Site destroyed

Tapes that can be removed to an off-site location solves #4. :-) Any solution that can store data off-site will work. I've seen a lot of issues with swapping USB drives - mostly of the drive randomly disconnecting variety.

HTH

MidnightOne
0
 
MidnightOneCommented:
It's a balancing act between finances and recovery in your case. I usually recommend the following as a best practice, although it's pricey in the tapes it consumes:

Rotating tapes:

Full on Fridays
Differentials M-th

Keep four weeks of these.

Take the last full backup every month and send off-site permanently.

HTH

MidnightOne
0
 
DVation191Author Commented:
So are you suggesting a tape drive for each server?
0
Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

 
MidnightOneCommented:
Not at all. A single tape drive (or tape library if necessary for the capacity of data you're backing up) will suffice.

Given your full backup is already in the 500GB+ range, I'd recommend a tape library. It'll make life that much easier if/when the fulls go to multiple LTO tapes.
0
 
MidnightOneCommented:
As far as backup software, I've been pretty happy with Veritas / Symantec Backup Exec. It's a very intuitive product to use.
0
 
DVation191Author Commented:
If we bought a LTO autoloader, it has to attach to at least one server, right? And that server would be the one also running the Backup Exec software? How does the data get from the other servers onto the tape? Over the network?
0
 
MidnightOneCommented:
Exactly. With Backup Exec you can install remote agents to get the data from the other servers. They have a whole litany of them for SQL, Oracle, Exchange, open files and remote servers.

Where you have a gigabit backbone, the slow part is the tape drive. :-)
0
 
DVation191Author Commented:
Great - I think I have a good understand of what you are proposing. Also sounds like the expensive part here might be the software along with all the agents.

Any particular reason you feel this solution works better than a disk-based solution?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.