<div>
I use this to populate my DBA Dashboard<br />
<br />

<pre><code id="code-20-38900155-1">SELECT @@SERVERNAME AS ServerName, database_id AS ServerDatabaseID, Name, create_date as CreateDate,
CASE	WHEN compatibility_level = 80 THEN 'SQL 2000' 
		WHEN compatibility_level = 90 THEN 'SQL 2005'
		WHEN compatibility_level = 100 THEN 'SQL 2008'
		WHEN compatibility_level = 110 THEN 'SQL 2012'
		ELSE NULL END AS DatabaseCompatibilityLevel,
Recovery_model_Desc AS RecoveryModel
FROM sys.databases</code></pre>
</div>


<div>
Or you could do each DB Manually in SSMS,<br />
<br />
Right Click the DB, Properties, Options
</div>


<div>
Refer:<br />
<a href="http://msdn.microsoft.com/en-us/library/ms175987(v=sql.105).aspx" rel="ugc">http://msdn.microsoft.com/en-us/library/ms175987(v=sql.105).aspx</a>
</div>


<div>
@Tony303, what do you mean by &quot;DBA Dashboard&quot;??
</div>


<div>
Hi Matrix,<br />
I made a small database and SSRS reports that gather the health of my SQL Servers and Databases.<br />
The DBA dashboard is just the glance at everything in one screen.
</div>


<div>
<div class="content wysiwyg-content">
We use SQL 2008 server running on OS: Windows 2008 R2.<br />
<br />
I'm not very familiar with SQL 2008. I've only used older versions.<br />
<br />
How can I check to see Which database recovery method is used (full, simple, etc…)?<br />
<br />
Please provide steps.<br />
<br />
Thanks!
</div>
</div>


We use SQL 2008 server running on OS: Windows 2008 R2.

I'm not very familiar with SQL 2008. I've only used older versions.

How can I check to see Which database recovery method is used (full, simple, etc…)?

Please provide steps.

Thanks!

I use this to populate my DBA Dashboard

(CODE)

Or you could do each DB Manually in SSMS,

Right Click the DB, Properties, Options

Refer:
http://msdn.microsoft.com/en-us/library/ms175987(v=sql.105).aspx

@Tony303, what do you mean by &quot;DBA Dashboard&quot;??

Hi Matrix,
I made a small database and SSRS reports that gather the health of my SQL Servers and Databases.
The DBA dashboard is just the glance at everything in one screen.

How can I check to see Which database recovery method is used (full, simple, etc…)?

We use SQL 2008 server running on OS: Windows 2008 R2.

I&#39;m not very familiar with SQL 2008. I&#39;ve only used older versions.

How can I check to see Which database recovery method is used (full, simple, etc…)?

Please provide steps.

Thanks!

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.