?
Solved

Recommendations on a backup strategy

Posted on 2005-03-07
10
Medium Priority
?
329 Views
Last Modified: 2010-04-03
Hi all,

I have a Powervault 132T and 5 SDLT tapes.  I need to back up the following:

-2 Windows 2003 Domain Controllers
-1 Member server running SQL 2000
-1 Member server (just files and home folders)
-1 Exchange 2003 server

I am using Brightstor 11.1 and I have the SQL agent installed as well as the Exchange agent installed. I have Backup Agent for Open Files installed on the member server that holds home folders and files.  Given this scenario, what would the best backup strategy be?

Thanks.

0
Comment
Question by:valicon
9 Comments
 
LVL 18

Accepted Solution

by:
Steve McCarthy, MCSE, MCSA, MCP x8, Network+, i-Net+, A+, CIWA, CCNA, FDLE FCIC, HIPAA Security Officer earned 1200 total points
ID: 13476763
Here is what I do,

I do a full backup of my system every Tuesday Night, with Differentials to the same tape every other night.  This way, I change the tape out once per week and if I ever need a restore, I use the full backup with the last Differential.  You have an excellent product there with lots of capabilities.

What I also do is make a single Master Backup and take that offsite for Storage.

I woul recomment you increase your number of tapes.  I currently use 12 in a rotation to give me 3 months of backups on hand at any 1 time.  I also Use Veritas, but Brightstor with the agents will do the same for you.

Having said all that, each network is a little different.  If your SQL data, for example is so critical, you might want that backed up a few times a day.....  You don't need to run a compare each time, but run one to make sure it works and then occasionally, restore a few non critical files just to make sure.

0
 
LVL 18
ID: 13476780
BTW....  The reason I choose Tuesday for the Tape change is that there are very few holidays that would fall there and it's a pretty good bet that the office will be open and someone here on a Tuesday..   Also, the First Tuesday of the Month I clean my tape drives before putting in the new tape.
0
 
LVL 12

Author Comment

by:valicon
ID: 13476940
Concerning your rotation, you say you have 3 months of backups on hand at any one time. How are you rotating the tapes?  Do you put a new tape in for the full backup every Tuesday and keep the prior weeks full backup?  For the single master backup, would that be monthly?
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
LVL 3

Assisted Solution

by:joe-quick
joe-quick earned 800 total points
ID: 13481089
I prefer doing a complete back-up every night myself so that incase of a crash I only have to restore 1 tape not 2.
Plus the network is practically dead from 12am - 4am so I have time. The rotation Sam gave you is a good one, and is utilized by most  IT Admins.

He doesnt have a monthly backup he has tape for each of the previous weeks, and each day is added on to the end of the tape that contains the full backup. 12 tapes = 12 weeks = 3 mos
The only thing you could change is doing your differential backup on a different tape.


Depending on what your needs are you can keep as many weeks as you want. I myself have 1 year worth of data on hand at any one time and keep 4 tapes for each year prior forever.
0
 
LVL 18
ID: 13482940
Yes, I put in 1 tape per week.  When I rotate through the 12, I start over.  The Master is seperate.  I do that when I have the server the way I want after being built and then I update it about every 6 months.  In some cases I use 2 Masters and just do a full backup to them every 6 months.

I only use 1 tape for a restore as my Full backup and the weekly differentials are all on the same tape.
0
 
LVL 23

Expert Comment

by:sciwriter
ID: 13484102
Backup strategy = whatever you want to accomplish, viz.:
Goal = to get maximum data recovery spread over longest interval
longest interval = maximum time for valid data - least time to obsolete data
maximum recovery = maximum recent data - least obsolete data.

Run the equations -- they are universal and they work -- and are totally independent of server type, etc.
0
 
LVL 12

Author Comment

by:valicon
ID: 13515867
Okay so here is the deal....I have a total of 15 tapes. What would be the very best back up strategy?  
0
 
LVL 18
ID: 13516219
Here is what I would do, as I said earlier,

I do a full backup of my system every Tuesday Night, with Differentials to the same tape every other night.  This way, I change the tape out once per week and if I ever need a restore, I use the full backup with the last Differential.  You have an excellent product there with lots of capabilities.

I currently use 12 in a rotation to give me 3 months of backups on hand at any 1 time.  I also Use Veritas, but Brightstor with the agents will do the same for you.

I would take the 13th and 14th tapes and make a Master Backup.  (A Full backup at this point in time that will not be in Rotation.)  In 6 months or if there is a major change to the system, I would again to a master backup to 1 of those Master tapes.  6 Months after that I would do a master backup to the other tape and rotate them every 6 months.  

So, in theory, you will have 3 months of backup at your finger tips, but could go back to the 6 month or 12 month point if need be.

Put #15 away for a spare in the event you need to archive old data or have a tape failure and need a quick spare.
0
 
LVL 12

Author Comment

by:valicon
ID: 13689191
Sorry for the delay I was out of town :)
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

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

Concerto Cloud Services, a provider of fully managed private, public and hybrid cloud solutions, announced today it was named to the 20 Coolest Cloud Infrastructure Vendors Of The 2017 Cloud  (http://www.concertocloud.com/about/in-the-news/2017/02/0…
The following article sheds light on easy-to-use steps to recover non-responding hard drives without data loss. Count on these approaches to fix undetectable, not responding, or non-working hard drives.
This video teaches viewers how to encrypt an external drive that requires a password to read and edit the drive. All tasks are done in Disk Utility. Plug in the external drive you wish to encrypt: Make sure all previous data on the drive has been …
This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…
Suggested Courses
Course of the Month7 days, 4 hours left to enroll

594 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