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
Related posts
Add comment
History
SQL SERVER DATABASE ADMINISTRATOR, DEVELOPER, began working with computers in 1980. Specializing in MS SQL Server 2000, 2005, Transact SQL, Stored Procedures, DTS.