an advice regarding backup plan


 
Thread Tools Search this Thread
Special Forums Hardware Filesystems, Disks and Memory an advice regarding backup plan
# 1  
Old 02-11-2009
an advice regarding backup plan

Hi all
i'm looking for good advice regarding backup plan becuase its first time to me handle large scale database expected to grow up 10000 - 20000 record per year with daily operations on it
I'm working as sysAdmin in educational organization ( junior level ) with mixed OSes environment including ( win2k3 - win2k8 - Linux -Unix Solaris Sparc & x86_x64 ) mixed RDBMS form different vendors including ( MS SQL Server - MySQL - Oracle ) mixed network infrastructure from different vendors as well as the hardware of servers .
In brief the core layout of my business is as follows:-
1- a dedicated web server serving business logic as webbased interface (only 1) as the clients of it will be few .
2- a dedicated database server serving only at most 2 databases beside system databases ( for now its SQL server 2005 in near future we will migrate to oracle ) and the main database initial size is about 1 GB for now it holds just dummy data for testing purposes .
its expected to grow up 10000 - 20000 record per year as i think all records are just text and numeric fields as i guess there are no BLOBs but i'm not sure .
3- backup devices are as follows entry level DAT drive with max size of 36 GB in native mode and red ray DVD drives .
and there's no budget for now or for the near future to buy new expensive storage .
the operation on data are daily ( 6 days per week 8-10 hours per day it's needn't to be up and online 24/7 for now ( daily data retrieval - daily data modification )
what should i do to put a good backup plan for 3 years from now and forward .
should i employee something like freeNAS or Openfiler or just getting enough with offline backups on tapes only also i want to decrease downtime in case of disasters as the dependency on the database will grow up day after day .
I'm looking for a tip in putting a good backup plan.
sorry for long
thanks for your helpful souls
# 2  
Old 02-27-2009
2 Things:
1)
Quote:
i want to decrease downtime in case of disasters as the dependency on the database will grow up day after day .
For that you will have to burn some DVDs with an OS image or bootable DAT...
You need for it to go fast the full OS with backup/restore utility you use...

2)
We dont know your volumetry... 20.000 records of 1 kb isnt the same as 5 Mb...

If you have no budget for backup/restore you cannot plan DR and so, who will be blamed once the disaster occured?

I would look for a little backup device that does deduplication, I saw some less than 5000 $ that can hold almost a TB...
# 3  
Old 03-05-2009
Thank you
# 4  
Old 03-05-2009
Overland has some interesting very small appliance:
Data Backup, Data Protection Solution, Data Protection Software, Data Disaster Recovery, Snapshot Software: Overland Storage
like:
Overland Storage : REO 1550

I suppose if you search a bit, you may be surprised by the choice and pricing of what can be produced today...
Login or Register to Ask a Question

Previous Thread | Next Thread

7 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Advice on a backup script, maybe one is out there already?

Hi, Not sure whether this is the right place to post it. I decided to post it here 'coz Advanced and Expert users will most likely have the answer to what I am looking for. I want to backup scripts that I have access to to a tar file file and zip it. At the moment I am creating a directory... (4 Replies)
Discussion started by: newbie_01
4 Replies

2. Shell Programming and Scripting

rsync backup mode(--backup) Are there any options to remove backup folders on successful deployment?

Hi Everyone, we are running rsync with --backup mode, Are there any rsync options to remove backup folders on successful deployment? Thanks in adv. (0 Replies)
Discussion started by: MVEERA
0 Replies

3. What is on Your Mind?

Plan to Buy a New Laptop

It is time for me to buy a new laptop computer and i was searching the net for the last few days looking for one. The results haven't really been satisfying and i thought you might have information i lack - if so, i'd be grateful for sharing it with me and the probably interested audience. What... (22 Replies)
Discussion started by: bakunin
22 Replies

4. AIX

Plan to shutdown servers

Hello everyone I need to shutdown all my servers and my storage. I would like to hear your opinions about this. This is my little plan about all this. 1.-Stop the applications 2.-Stop the webservers 3.-Stop the ihs 4.-Stop the databases 5.-Verify no process are running 6.-Close the... (1 Reply)
Discussion started by: lo-lp-kl
1 Replies

5. What is on Your Mind?

401 Keg Plan

If you had purchased $1,000 of AIG stock one year ago, you would have about $40.00 left. With Lehman, you have about $6.00 left. With Fannie or Freddie, you would have less than $5.00 left. But, if you had purchased $1,000 worth of beer one year ago, and had drunk all of the beer, then turned... (4 Replies)
Discussion started by: Neo
4 Replies

6. UNIX for Dummies Questions & Answers

Backup help/advice using TAR

Every day we back up all files on our system that are older than 7 days, so effectively we do a day's worth at a time. The way we do this is to issue a find command using mtime +7 - we then loop round and for each result we issue a MV to move the file to a newly created directory. We then TAR the... (20 Replies)
Discussion started by: tonysab
20 Replies

7. UNIX for Dummies Questions & Answers

plan

i want to make a program run when a person types 'finger USERNAME', username being my username. how can i do this? (2 Replies)
Discussion started by: cypher
2 Replies
Login or Register to Ask a Question