The Multifunctioning DBA

Apr 29 2011   8:01PM GMT

SQL Server Backups and who is responsible?

Colin Smith Colin Smith Profile: Colin Smith

Do you use a third party backup utility? If you do are you in charge of the tool and the infrastructure that it sits on? Well if you do then you are lucky. As a DBA I think that my first priority is to make sure that I have backups and backups that can be recovered of all of my Databases, production anyway. Well this is being taken away from me and I have some strong feelings about this and this morning a situation came up that proved to me that my frustration is justified.

We use a tool that another group is responsible for. They set up the backups, monitor the backups, and are also responsible for the database restores. I, as a DBA, have a major issue with this. I know that I, like many of you DBA’s out there, am a control freak. I have a need to know for sure that my databases are being backed up, that the backups are safe and secure, and that they are actually recoverable. The way that our system works right now I cannot really do much about anything. To help put my mind at ease I have written a script that will go out and look at every database that I have and report back on the last full backup date and put that into a database all my own so I can keep track of it over time. That helps now that I can alert that a database has not been backed up, but I still have a few issues with this set up.

So with this tool and the way things are set up currently I really feel like I am not able to do that part of my job effectively. I think I might have some real ammunition to fight this now though. Today a user needed a restore of a prod database and no one on that team was available. Bad that the restore had to wait but good for me to maybe get some things changed.

 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: