One of the things that a SQL DBA must do as often as possible is to check the SQL backups. The best will be to check them daily, but to be honest I do not have the time for that. At the moment I use “restore verify only” on a daily basis to check my backups, but that is not enough. My company has two disaster recovery tests per year and these tests are a great opportunity to check my backups. I also try to restore the databases from the core applications at least once a month. If you are a DBA and you are not currently checking your backups, my advice to you will be to start doing it as soon as possible. You don’t want to find out that your backups are corrupt during a disaster!
Checking the backups
I was born in Barranquilla, Colombia in 1975. When I was 17 I moved to Curacao where I lived 10 years and then move to The Hague, The Netherlands. I speak 4 languages (Dutch, English, Papiamento and Spanish). I'm a Systems Engineer graduated from The Hague University (http://www.thehagueuniversity.com/). I have been working in IT for over 15 years. Since November 2014 I started www.cenlinea.com a webportal were the focus is to make learning more fun. At Cenlinea we are currently promoting PLAYDIOM a new methodology to learn English. While currently working part-time time at Cenlinea, I am also working as Senior Princiapal Consultant at www.ccgroep.com which helps me to keep up to date with Microsoft SQL Server, which I consider to be one of my favorite things in life as it has changed my life in many ways. I hope you enjoy my blog and if you want to send a question, just drop me a mail at email@example.com or firstname.lastname@example.org View all posts by isalom