to find recovery model in sql server

• Sri-259951

  Old Hand

  Points: 338

  More actions

  April 12, 2006 at 3:09 am

  #112986

  hi,

  I need to find the recovery model of a database in sql server using sql queries

  regards

  Sri

• runaldo

  SSCommitted

  Points: 1682

  More actions

  April 12, 2006 at 3:16 am

  #632034

  SELECT DATABASEPROPERTYEX('Northwind', 'Recovery')

  It then displays the Recovery Models.

  Look at DATABASEPROPERTYEX in Books Online (the helpfile )

  Runaldo

• Sri-259951

  Old Hand

  Points: 338

  More actions

  April 12, 2006 at 3:24 am

  #632036

  hi Runaldo,

  Thx for ur help, it works

  regards

  Sri

• srijan

  SSC Enthusiast

  Points: 171

  More actions

  March 27, 2007 at 11:23 am

  #697228

  That will work for 2000 and 2005; what about 7?  Is there a way to find the backup/recovery model of a database in sql 7?