Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Until now, I was doing my SQL Backups using USB Hard disk, and copying that to my local computer. After that, I went zipping and burning onto DVDs.

Now I want to push that on more professional and more robust level.

What kind of hardware is best for storing and backuping SQL databases ?

My environment looks like:

  • two MS-SQL-Server 2008, One production database and other replicated for reporting
  • My apps is not mission critical and I can afford my self down time even and for 20 hours.
  • My main database is around 32GB when is in backup, others is around 10GB.
  • I think that I do not need large and long historical data, two or tree snapshots should be OK for me.

Here are further questions:

  • Should I looking for hardware with TAPES?
  • Does NAS (network attached storage) provide a good solution ?
  • If I go with NAS beside RAID, to what should I pay more attention?
  • Which protocol is essential for NAS so SQL can do backups easily?
  • Today's SHOHO NAS servers is pretty cheap and available, Should I avoid them ?

Any other suggestions is much appreciated.

share|improve this question

closed as off-topic by Paul White, Phil, bluefeet, Aaron Bertrand Jan 26 '15 at 14:40

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope." – Paul White, Phil, bluefeet, Aaron Bertrand
If this question can be reworded to fit the rules in the help center, please edit the question.

I'd go NAS in your scenario. You could output backups directly to the NAS. – Eric Higgins Mar 1 '12 at 22:31
up vote 2 down vote accepted

My opinion: A NAS with RAID 5 would be a good solution. This would give you decent fault tolerance without costing too much space. You can even get NASes that support AD authentication, thereby taking your security up one level. This will take care of your onsite backup needs.

Tape backups will provide you with an offsite storage solution, but the price difference is much more for the tape drive and management software.

Don't go for the cheapest NAS hardware. That was a decision taken by the management at my previous company. Due to inconsistent behavior/performance they dropped the solutions after paying full price for implementing NASes in 11 divisions. Check out reviews about the NAS before buying them.

share|improve this answer
While this is a good answer (+1), I would always push for RAID10 over RAID5 due to disk maintenances issue down the road. – RolandoMySQLDBA Mar 2 '12 at 19:53

Not the answer you're looking for? Browse other questions tagged or ask your own question.