Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
faizankh
Starting Member
8 Posts |
 Posted - 2007-02-22 : 13:54:43
|
| I have questions regarding the recovery models.I have a Production server that has 200 client specific databases, most of them are in Simple Recovery Model and some of them are in Full Recovery Model. My question is, Is there a system store proc or query to check which database are in Simple or Full Recovery Model?Please help. |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-02-22 : 14:17:11
|
| SELECT DATABASEPROPERTYEX('MyDatabaseName', 'Recovery')e.g. 'SIMPLE'Kristen |
 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-02-22 : 16:37:04
|
| [code]select Recovery = convert(varchar(15),databasepropertyex(a.name,'Recovery')), DB_Name = a.namefrom master.dbo.sysdatabases aorder by a.name[/code]CODO ERGO SUM |
|
|
|
|
|
|
Recovery Models