Post reply

Viewing SQL 7 DB Recovery Mode

  • 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

  • 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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply