an advice regarding backup plan Post: 302286519

Sponsored Content

Special Forums Hardware Filesystems, Disks and Memory an advice regarding backup plan Post 302286519 by h@foorsa.biz on Wednesday 11th of February 2009 10:28:52 AM

02-11-2009

Registered User

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

h@foorsa.biz

View Public Profile for h@foorsa.biz

Find all posts by h@foorsa.biz

7 More Discussions You Might Find Interesting

1. 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. 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...

3. 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. 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...

5. 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...

6. 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.

7. 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...

LEARN ABOUT DEBIAN

tap::parser::result::plan

TAP::Parser::Result::Plan(3pm)				User Contributed Perl Documentation			    TAP::Parser::Result::Plan(3pm)

NAME

       TAP::Parser::Result::Plan - Plan result token.

VERSION

       Version 3.25

DESCRIPTION

       This is a subclass of TAP::Parser::Result.  A token of this class will be returned if a plan line is encountered.

	1..1
	ok 1 - woo hooo!

       1..1 is the plan.  Gotta have a plan.

OVERRIDDEN METHODS

       Mainly listed here to shut up the pitiful screams of the pod coverage tests.  They keep me awake at night.

       o   "as_string"

       o   "raw"

   Instance Methods
       "plan"

	 if ( $result->is_plan ) {
	    print $result->plan;
	 }

       This is merely a synonym for "as_string".

       "tests_planned"

	 my $planned = $result->tests_planned;

       Returns the number of tests planned.  For example, a plan of 1..17 will cause this method to return '17'.

       "directive"

	my $directive = $plan->directive;

       If a SKIP directive is included with the plan, this method will return it.

	1..0 # SKIP: why bother?

       "has_skip"

	 if ( $result->has_skip ) { ... }

       Returns a boolean value indicating whether or not this test has a SKIP directive.

       "explanation"

	my $explanation = $plan->explanation;

       If a SKIP directive was included with the plan, this method will return the explanation, if any.

       "todo_list"

	 my $todo = $result->todo_list;
	 for ( @$todo ) {
	     ...
	 }

perl v5.14.2							    2012-06-05					    TAP::Parser::Result::Plan(3pm)