Post reply

Is there a system table that can be queried which will output the recovery model of a database?

  • October 12, 2006 at 3:07 pm

    #170616

    I am curious if there is a way I can write a query to show the Database recovery setting?  If so would you please let me know what table or tables I need to utilize?

     

     

    Thanks in advance,

    Leeland

  • October 12, 2006 at 3:14 pm

    #665594

    try this:

    select DATABASEPROPERTYEX( 'yourDBName' , 'Recovery' )

     

  • October 13, 2006 at 7:24 am

    #665722

    PERFECT...thanks for the info...

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

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