Here’s a quick list of some useful TSQL scripts to help administer a server and troubleshoot problems:

• TSQL to get Index Fragmentation Levels
• TSQL to Get Backup History of a Database
• Find and review all backup files on a drive