September 28, 2011 at 1:38 pm
I'm fairly new at this place and there is an instance with a gazillion databases.
Is there a way to find out which databases are in simple recovery mode other than right clicking each database and going to options.
It's a SQL Server 2000 instance.
Thanks
September 28, 2011 at 1:39 pm
Try master.dbo.sysdatabases. I think that's what it was called in SQL 2000. It's sys.databases in 2005 and beyond.
You can query that, and it has the recovery model in there.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 28, 2011 at 1:55 pm
In SQL 2000, the recovery model is not displayed in the system catalogue like it is in 2005. However, thanks to the magic of functions you can retrieve it by using the following script.
select name, databasepropertyex(name, 'Recovery') as RecoveryModel from master.dbo.sysdatabases order by name
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 28, 2011 at 2:50 pm
THANKS!
September 28, 2011 at 3:00 pm
You're welcome.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply