Solved

Backup Disaster Recovery Best Practices

Posted on 2007-11-29
8
299 Views
Last Modified: 2013-12-05
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.
0
Comment
Question by:DVation191
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
8 Comments
 
LVL 26

Expert Comment

by:MidnightOne
ID: 20375562
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
 
LVL 20

Author Comment

by:DVation191
ID: 20382558
So are you suggesting a tape drive for each server?
0
 
LVL 26

Expert Comment

by:MidnightOne
ID: 20383514
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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 26

Expert Comment

by:MidnightOne
ID: 20383519
As far as backup software, I've been pretty happy with Veritas / Symantec Backup Exec. It's a very intuitive product to use.
0
 
LVL 20

Author Comment

by:DVation191
ID: 20383666
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
 
LVL 26

Expert Comment

by:MidnightOne
ID: 20383915
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
 
LVL 20

Author Comment

by:DVation191
ID: 20384004
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
 
LVL 26

Accepted Solution

by:
MidnightOne earned 300 total points
ID: 20384219
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

Featured Post

[Webinar] How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Are you looking to recover an email message or a contact you just deleted mistakenly? Or you are searching for a contact that you erased from your MS Outlook ‘Contacts’ folder and now realized that it was important.
Microservice architecture adoption brings many advantages, but can add intricacy. Selecting the right orchestration tool is most important for business specific needs.
This tutorial will walk an individual through the process of configuring basic necessities in order to use the 2010 version of Data Protection Manager. These include storage, agents, and protection jobs. Launch Data Protection Manager from the deskt…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question