Asking for Help

I always think it's a great idea to ask for help. When I was a kid, my parents taught me that it's always a good idea to ask for help - the worst that will happen is they'll say no. In IT there is too much to learn so I always think it's a great idea …

Cleanup Backup History

While looking at long running queries today I noticed that one of our worst performing queries was a monitoring tool that checked when the last backup ran. SELECT database_name = DB_NAME(DB_ID([database_name])) ,         type = [type] ,         backup_start_date = MAX([backup_start_date]) ,         backup_finish_date = MAX([backup_finish_date]) FROM    msdb..backupset WHERE   DB_ID([database_name]) IS NOT NULL GROUP BY DB_NAME(DB_ID([database_name])) ,[type] I had …

Failing Mirror Backups

Failing Backups! Is there anything more worrying for a DBA? Recently we have been having multiple failures a week for our full and differential backups. We use Ola Hallengren's backup scripts, and unless you are using a 3rd party product, you should be using Ola's scripts as they are amazing and so simple to use. We …