Can somebody help with an SQL Statement to list the Recovery models for
all the Databases in a server. I am trying to use the status column from sysdatabases..but i am not able to get the right statement.
Any help/references asap...
Thanks in advance.
Sasi.For SQL 2000
select name, databasepropertyex(name, 'Recovery') as RecoveryModel from master.dbo.sysdatabases order by name
For SQL 2005...
select name, recovery_model, recovery_model_desc from master.sys.databases
Good luck with it...
No comments:
Post a Comment