Checking database backup history

Sometimes, especially with large databases, the duration of a backup can be significant (e.g. multiple hours). So, if you’re wondering exactly how far along a backup is, and when it is estimated to complete, you can run the query below I hope that helps!

How to get a database out of Recovery Pending state

One of my clients recently suffered an outage for their production environment. The database structure includes Report Server Report Server Temp Transactional Transaction History During the outage all databases were in “Suspect” mode. I had never seen this status before, but it is not fun….

View index details by Table

Here’s a handy script to see the indexes available on a given table. The script displays all columns associated with the index, and identifies if it is a index key column, or an include. Hopefully you will find it helpful with database tuning, as I…