The SQL 2005 BPA can be found here: SQL Server 2005 Best Practices Analyzer Do: Take full, differential, and/or log backups (whichever is appropriate) before running the analyzer (so you don't get warnings/information messages that clutter the report) Prior to running the BPA, run DBCC CHECKDB commands on your DBs...