T-SQL – Checking Database Recovery Model

T-SQL – Checking Database Recovery Model

If you want to check current Database Recovery Model, then below script would be a great help.

SELECT [name],state_desc,recovery_model_desc FROM sys.databases

Please Note:
There are 3 types of recovery model in SQL Server:

  1. Full – Requires log backups.
  2. Simple – No log backups.
  3. Bulk Logged – Requires log backups ( minimal logging)

To read more about recovery models read the below MSDN Article

http://msdn.microsoft.com/en-us/library/ms189275.aspx

Advertisements

One thought on “T-SQL – Checking Database Recovery Model

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s