List Database Recovery Mode on a server

\ by

A handy script to have around for a nice report.

SELECT LEFT(name,50) DatabaseName, CONVERT(VARCHAR(50),DATABASEPROPERTYEX(name, 'recovery')) RecoveryMode  
    FROM sysdatabases 
    WHERE name NOT IN ('model','tempdb') 
    ORDER BY name
            

Posted in: SQL