Viewing SQL 7 DB Recovery Mode

• Jeff-67583

  SSCertifiable

  Points: 5625

  More actions

  November 13, 2003 at 2:50 pm

  #160216

  Hi,

  Is there a quick way I can display the recovery mode for multiple databases in SQL Server 7?

  Is there something similar as DATABASEPROPERTYEX (which in SQL2000, it has a "recovery" switch)???

  Many thanks.

  Jeff

  Many thanks. Jeff

• Jonathan

  SSC-Insane

  Points: 20427

  More actions

  November 13, 2003 at 5:13 pm

  #481992

  "Recovery model" was a new concept introduced with SQL Server 2000. The closest thing in SQL Server 7 would be to check the "trunc. log on chkpt." and "select into/bulkcopy" settings with sp_dboption <dbname>, e.g.:

  
  
  exec sp_dboption northwind,'trunc'
  
  exec sp_dboption northwind,'bulk'

  ON and ON would equate to Simple, OFF and ON would be Bulk-Logged, and OFF and OFF would be Full.

  --Jonathan

  
  
  --Jonathan