Friday, March 23, 2012

Script to enumerate Recovery mode

Hi, I search a script that report me a list of all my several DB on my SQL
Servers, with which Recovery model they have (simple,full or bulked). Did
somebody have something? ThanksMV
select name,databasepropertyex(name,'recovery') from master..sysdatabases
"MV" <MV@.MV.MV> wrote in message
news:uKu5FP7PHHA.4824@.TK2MSFTNGP02.phx.gbl...
> Hi, I search a script that report me a list of all my several DB on my SQL
> Servers, with which Recovery model they have (simple,full or bulked). Did
> somebody have something? Thanks
>|||Hello,
YOu could also use:-
sp_helpdb
THanks
Hari
"MV" <MV@.MV.MV> wrote in message
news:uKu5FP7PHHA.4824@.TK2MSFTNGP02.phx.gbl...
> Hi, I search a script that report me a list of all my several DB on my SQL
> Servers, with which Recovery model they have (simple,full or bulked). Did
> somebody have something? Thanks
>|||I you need precise information like only recoverymodel then use Uri's query
statement if you need complete details Hari's SP_HELPDB will be useful.
"Hari Prasad" wrote:
> Hello,
> YOu could also use:-
> sp_helpdb
> THanks
> Hari
> "MV" <MV@.MV.MV> wrote in message
> news:uKu5FP7PHHA.4824@.TK2MSFTNGP02.phx.gbl...
> > Hi, I search a script that report me a list of all my several DB on my SQL
> > Servers, with which Recovery model they have (simple,full or bulked). Did
> > somebody have something? Thanks
> >
>
>

No comments:

Post a Comment