SQL Server recovery models often incorrectly referred to as (MS SQL Recovery Mode) define how your SQL Server database will treat your transaction logs. There are 3 SQL Server Recovery Models to choose from, Simple, Full and Bulk Logged. Simple: The transaction log is written to as a transaction runs and once the transaction completes what is in the transaction …

SQL Server Recovery Models Explained Read more »

Today I released the June 2017 version of Database Health Monitor, you can get it on the download page at http://DatabaseHealth.com.  Here is what it included. Version 2.5.5 Release Notes Version 2.5.5 is the June, 2017 release of Database Health Monitor New Features in 2.5.5 Added a Recovery Model column to the Backup Status Report based on a customer request. …

Database Health Monitor June 2017 Version Released Today Read more »

On my computer I run SQL Server 2012, and I use a number of test or development databases. I don’t run backups on these because I don’t care if they get destroyed since they are easy to replace. Recently I upgraded to a SSD, and now my C:\ drive which I am running SQL Server from is really fast, and …

Shrinking a Log File on a Test or Development Server Read more »