I have been asked to specify a hardware/software solution for the SQL Server backups in my organization. Currently I have nightly jobs in SQL Server that back up our databases and transaction logs to disk (to a share on another server), and then our Systems staff does a nightly backup of that server.
We have purchased the SQL Server Agent for Backup Exec, but our Systems staff only intends to use it for disaster recovery (i.e. they're only going to keep the previous night's backup).
If you had a fairly unlimited budget, what hardware/software would you recommend? I'm trying to decide whether it would be best to just get another copy of Backup Exec (and either have Backup Exec do the backups directly from SQL or just back up the backup files from disk), or whether I should use some sort of juke box or tape library system...
If anyone has any advice or recommendations, I'd very much appreciate it. Our goal is to be able to recover any of these files to restore a database as it was on any given day.
-- "It's not that I'm lazy... it's that I just don't care."
========================================== Cursors are useful if you don't know sql. DTS can be used in a similar way. Beer is not cold and it isn't fizzy.
We do have a SAN (our production SQL Server is running as a fail-over cluster using the SAN). I believe that our Systems staff does not want us to store the files there (and to be honest, I'd be a little worried about having the backups in the same place as the production data).
They've suggested some sort of tape library, which seems like a good idea to me, but I don't know anything about them so I'd have no idea what to purchase. Does anyone have any recommendations or advice on where to look for product reviews?
Thanks again!
-- "It's not that I'm lazy... it's that I just don't care."
You can buy a Quantum tape drive and attach it to the SAN. You can then buy ComVault or Veritas to backup directly over the SAN. This keeps the backups from hitting the main network.
Backup system recommendations
Posted - 01/10/2005 : 11:28:28
