Post reply

Check Recovery Model for a DB

  • June 27, 2006 at 7:37 am

    #191117

    What is an easy way to check the recovery model being used for a Database without SS Management Studio.

     

    Thank you

    Best Regards,

    ~David

  • June 27, 2006 at 7:59 am

    #646061

    select

    database_id,name as database_name,recovery_model, recovery_model_desc FROM sys.databases

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

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