Legato Agent hanging with MS SQL Server 2000.. backup advice?
Posted on 2006-06-09
I'm the sysadmin for my company, and we host most of our production servers at an external NOC. This NOC does our backups on a separate network using Legato.
Many times a backup job for a not so huge database takes over 10 hours -- much longer than it should. I believe it's because it is hanging. Since Legato is the only way for us to interface with their backup site, the Legato SQL Agent puts a real huge toll on our database, and I'm looking for options (and assigning BIG points for this).
Anyways, as I understand it the native SQL backup utility isn't enough, because it doesn't allow us to restore a single table but rather, the entire database. I'm not a DBA, so I can't speak to the truth of this but I would like to have some information to bring to my boss to get an alternative solution, because Legato hangs constantly and we can't be without some of our DBs, they are the core of our business.
I would appreciate, given our situation, a proper backup strategy for databases. We have a DBA here as well but I just want to get independant answers without involving him (thus tainting my question) and then discuss it with him to come up with the best solution we can present to the boss. Keep in mind, doing our own tape backups is rather impossible because we are limited to the rack space we have and getting tape libraries to back up all of our databases, and additionally worry about tape swaps and off site storage -- this is all taken care of us for by the NOC.
I would really appreciate any help you folks can give.