Post reply

to find recovery model in sql server

  • April 12, 2006 at 3:09 am

    #112986

    hi,

    I need to find the recovery model of a database in sql server using sql queries

    regards

    Sri

  • April 12, 2006 at 3:16 am

    #632034

    SELECT DATABASEPROPERTYEX('Northwind', 'Recovery')

    It then displays the Recovery Models.

    Look at DATABASEPROPERTYEX in Books Online (the helpfile )

    Runaldo

  • April 12, 2006 at 3:24 am

    #632036

    hi Runaldo,

    Thx for ur help, it works

    regards

    Sri

  • March 27, 2007 at 11:23 am

    #697228

    That will work for 2000 and 2005; what about 7?  Is there a way to find the backup/recovery model of a database in sql 7?

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

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