September 1, 2009 at 1:59 pm
We are starting to test using LiteSpeed to back up our databases directly to TSM, and are having some success, but also a few failures. We are having issues with doing the restore_verifyonly step to verify the backup, on one server with larger databases (300+GB) the verify step fails. On one database it fails constantly, on others it fails intermittently. We have tried working with Quest to find an answer, but at this point it is being written off as a customer problem due to the error being "general network error". I am interested to know if other companies are successfully using LiteSpeed to TSM backups, or if they found a database size limitation or server limitations compared to doing traditional Litespeed to disk backups. Our management would like to know that there are other companies using the process successfully before we attempt to spend a lot of time on the project. All input appreciated!
September 2, 2009 at 8:15 am
Krista,
I was previously using SQLSafe, but the software constantly had failed backups, forcing me to look into other options. I currently use Litespeed to back up a couple of 10+ TB databases. By far, it's the best product I've used- and for the price/support, it hasn't been too bad.
Even after changing to Litespeed, I've seen this issue occur occasionally. One way I have worked around this is to stripe the backups out to 20 files. Keep in mind that this is for a 10+TB database - and compressing it using the L1 compression, no encryption. We also found that our core router was dropping packets occasionally, and after an upgrade, that fixed most of the issues.
Questions:
- Are you encrypting your backups?
- Are you compressing the backups?
- What compression level are you using?
If possible and you have the space, have you tried backing up the DB to several striped files, no compression, no encryption, directly to disk. Or is it a requirement for you to back up directly to tape?
This might not help, but I figured I'd throw it out there.
September 2, 2009 at 9:31 am
Ken,
We have LiteSpeed backups to disk followed by a push of the backup file to TSM running fine for the last 4 years , we are now trying to take the next step of running the backups directly to TSM. Tight times call for new innovation 😉 and I'm hoping we can return a lot of storage to our SAN team by sending all the backups to TSM and just keeping only a small amount of disk to store one copy of the largest database backup for emergencies. TSM from what I understand only allows backup up to one location, haven't looked to see if I can do multiple files but I will try it next.
Thanks,
Krista
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply