Category: Recovery Model

  • T-SQL Stored Procedure to Get DB’s Recovery Model

    As a lazy DBA, I am not a fan of writing ad-hoc queries, therefore I keep wrapping up codes which I think that will come in handy some time later. Here is the piece of T-SQL that checks the recovery model of all or a specific DB on an instance. [sourcecode language=”SQL”] /* .SYNOPSIS Stored…