Require a permanent Backup Solution

5 pts.
Tags:
Backup & recovery
Hi,I would like suggestion as to what is the best way to backup my data. Previously we had a tape drive and our backups were scheduled to be backing up there. But when the tape drive failed which somehow led to our server crashing the tapes were not pointing to the correct data at all. It was poiting to 3 months back data upon restoring. So we have now decided to do away with the tapes. We have 11 databases in sql server that we backup. ten are small and the main db is 4 gb currently. Before it grew to 4 gb the db maintenance plan was scheduled to backup on an external 40 gb hard disk and then i would zip the files and burn a cd of all the databases. I cannot do that anymore coz the main database cannot be zipped as its too big. Win zip allows max 4 gb to be zipped. Also all cannot fit on a Cd after even being zipped. I need a permanent solution as to what is the best way to do backups in my case excluding anything to do with tapes. The main database will keep on growing and also i cannot backup on an external hardisk alone. I should have another copy of it somewhere as well. Please advise me as to what i should do in my case. desperate for an answer. princess8

Answer Wiki

Thanks. We'll let you know when a new response is added.

One option you can consider for long-term backup instead of the CD drive is a DVD drive. The dual-layer ones can take up to 9GB and are extrememly convenient and not expensive.

Discuss This Question: 9  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • FCHikerboy
    Another option, particularly if a DVD drive is out of the price range (Dual-Layer DVD-R's are expensive), is a CD-RW Jukebox. They come in two drives or more and the software that comes with them is intelligent enough to span multiple CD's. Not sure what database it is, but you could also figure out a way of automating spliting the main 4gb database in half, so it could be zipped.
    0 pointsBadges:
    report
  • Smiley
    I would go back to tape. You can back up to 30 Gig or more on a tape backup. Get Backup Exec by Veritas which is one of the best backup solutions you can get. Once your backups are set up, you can add notification to the job and have Backup Exec email you with job success or failure. No backup solution will work 100% of the time unless you take time and check it. Do a restore every once in a while to make sure that the data is being backed up correctly. Even CDs or DVDs have a life span and unless you validate the files after your burn is complete, you can't be sure that no errors have occured.
    0 pointsBadges:
    report
  • Klewis
    I must agree - any backup solution is reliable, if you take time to monitor it and test it from time to time. Tape backup is also very cost effective in the data range you're talking about. A single LTO-2 tape drive can stream at 30MB/s and write 200GB native to one cartridge. Both the drive and media are really inexpensive and highly reliable, in the long run.
    0 pointsBadges:
    report
  • Jaseman
    I currently use Veritas 9.1 and backup a 60 gig SQL database, along with dozens of other servers, some with SQL databases. We are moving to a hardware solution. Look at Idealstor. I believe they have the best soluution available right now. It will be much easier than zipping and burning all day long.
    0 pointsBadges:
    report
  • Ramheka
    Hi there Get your self a firewire or a high speed USB2 external hard drives ( they are cheap, fast and they come with big capacity over 300GB) just connect them to anywhere your servers if you want and direct the backups to them and they are lightweight too
    0 pointsBadges:
    report
  • Antila
    Hi Princess8 After reading your message I'm confident that you need to start somewhere else. What you need to do is to form a backup strategy, and make sure that the strategy covers reliability test of your backup. I would recommend you to use tape. It is by far the most reliable and fast media, and you have the opportunity to take your backup of site. This gives you a high level of security against dataloss. You will of cause need to have a reliable backup software, that could be BrightStor ARCserve from Computer Associates or as mentioned, Veritas BackupExec. The benefits here is that they have agents for backing up SQL servers on the fly, they can perform fast and reliable disaster recovery and can also backup your mail server, if Exchange, on single mail or mailbox level. But as I wrote in the beginning - make a strategy. Be sure to rotate the tape media, be sure that you test the backup on a regular basis by trying to do a restore, be sure to add new tapes regularly, keep them in a safe environment, etc. Feel free to contact me if you need further advice.
    0 pointsBadges:
    report
  • Glennp7777
    I don't have to backup MS SQL data, so maybe I'm out on a limb here.. but after you spend the money for licensing the Veritas or Computer Associates software plus the cost of the tape backup hardware and the machine that connects it to the network (given that it is probably a dedicated backup server; would you not be better off with a server dedicated to backups with hot-swappable hard drives? The hardware is cheaper than the combination mentioned above. The software solution to backing up can take any number of paths to a solution. One of the paths to a solution that I use and might suggest is a Linux machine with rsync and ssh, with additionally, SaMBa or NFS. You could build a hell of a box like this and spare hard drives for $4000.00! Er.. at least I could!
    0 pointsBadges:
    report
  • Antila
    As stated in my previous message, what you need Princess8 is to determine your strategy; Do you "just" need to have the latest backup, do you need to be able to restore data from a week ago, or do you need to ensure that you can restore data from a month or even from a year ago ? Can you live with a backup being kept local, or do you need a backup which can be taken off-site to a secure location (in case of fire or burglary this is the only way to get back in business!). My philosophy is that hardware is replaceable, data isn't !
    0 pointsBadges:
    report
  • 12spot
    well, as far as i know. the best way to backup large db is using a tape drive. i dunno other solution. what server are you using right now? if i may know.
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following