Re: Write query to find Recovery Model...
From: Keith Kratochvil (sqlguy.back2u_at_comcast.net)
Date: 06/09/04
- Next message: Jonathan Blitz: "Getting identity when using trigger"
- Previous message: John Bell: "Re: Write query to find Recovery Model..."
- In reply to: Hari Prasad: "Re: Write query to find Recovery Model..."
- Next in thread: Keith Kratochvil: "Re: Write query to find Recovery Model..."
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 9 Jun 2004 12:05:39 -0500
I didn't even think of master..sysdatabases. I went right for the unsupported & undocumented sp_MSforeachdb. Your solution is much better than mine. Still, either will work and both show techniques that are helpful.
-- Keith "Hari Prasad" <hari_prasad_k@hotmail.com> wrote in message news:OOnGANkTEHA.164@TK2MSFTNGP12.phx.gbl... > Hi, > > Execute the below statement from query Analyzer:- > > select Name,convert(sysname,DatabasePropertyEx(name,'Recovery')) as > Recovery from master..sysdatabases > > or you can use the below procedure > > sp_helpdb > > Thanks > Hari > MCDBA > > > "Brett Davis" <bdavis123@cox.net> wrote in message > news:#vSuBIkTEHA.3988@TK2MSFTNGP10.phx.gbl... > > Is there a query that i can write to find out the recovery models for all > of > > my system and user databases on my server? There has to be a better way > > then manually going through the databases one by one through Enterprise > > Manager. > > > > I am using SQL Server 2000. > > > > Please advise... > > > > Cheers! > > Brett > > > > > >
- Next message: Jonathan Blitz: "Getting identity when using trigger"
- Previous message: John Bell: "Re: Write query to find Recovery Model..."
- In reply to: Hari Prasad: "Re: Write query to find Recovery Model..."
- Next in thread: Keith Kratochvil: "Re: Write query to find Recovery Model..."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
