I don’t consider myself a SQL Server expert so here’s a SQL Server Administrator Cheatsheet of queries for managing SQL Server. Query all Database Files List all the Data and Log files for your database with the file sizes.