How To Check Recovery Model

• Maciej Szymanski

  Old Hand

  Points: 343

  More actions

  April 14, 2003 at 5:40 am

  #80592

  Hi all,

  I've been searching everywhere but can't find, how to check in T-SQL the recovery model of certain database. Please help.

  Thanks

  With regards

  Maciej Szymanski

  
  With regards
  
  Maciej Szymañski
  

• Steven.

  SSCrazy Eights

  Points: 9806

  More actions

  April 14, 2003 at 5:48 am

  #454030

  Try the DATABASEPROPERTYEX function

  eg.

  SELECT DATABASEPROPERTYEX('Pubs', 'Recovery')

  Steven

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736280

  More actions

  April 14, 2003 at 9:49 am

  #454091

  sp_helpdb also has the information for all dbs.

  Steve Jones

  sjones@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/sjones

  http://www.dkranch.net