Posted by: 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.