The Multifunctioning DBA

Jul 30 2010   10:00AM GMT

Backup and Restore

Colin Smith Colin Smith Profile: Colin Smith


I am fighting a battle right now of whether or not I, the DBA, or the backup team at my company should be in charge of backups and restores of the SQL Server Databases in the company. We use Netbackup with a SQL Agent to back up the databases and I am still not sure that I am a huge fan of that. I see the things that it brings to the table and some of it is great. Some not so much. My biggest complaints is that Veritas says that the client needs to have Sysadmin role on the SQL Server. That always throws up a red flag and I hate that when I ask why they can not give me a good answer. Also I do not like that it limits my control over the backups and the restores. I am not apposed to using the tool but I am opposed to not being in control of it. I am the DBA and backups and restores are one of my primary responsibilities. I will fight this until the end and if I lose I will get in writing that I am not responsible in any way for backups and restores and therefore not held responsible for when a restore can not be completed.

Wish me luck

 Comment on this Post

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 other members comment.

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:

Share this item with your network: