Identifying the recovery model by code

• Ian Cook

  Say Hey Kid

  Points: 678

  More actions

  June 13, 2007 at 4:35 am

  #69827

  Hi,

  I want to be able to identify the recovery model of each database using TSQL.

  Can anyone point me in the right direction.  This is for SQL2000 SP4.

  Thanks

  Ian.

• Sugesh Kumar

  One Orange Chip

  Points: 27311

  More actions

  June 13, 2007 at 6:03 am

  #712571

  select databasepropertyex(databasename,recovery)

  should be ok for ur req.

  Cheers,
  Sugeshkumar Rajendran
  SQL Server MVP
  http://sugeshkr.blogspot.com

• Ian Cook

  Say Hey Kid

  Points: 678

  More actions

  June 13, 2007 at 6:21 am

  #712575

  Thanks.