Post reply

Wich table/database hold the info about the recovery model?

  • June 2, 2008 at 10:51 am

    #122511

    I need to know wich database hold the info about the recovery model of all databases using sql server 2005

    ie. - select * from sysdatabases or select * from sysobjects

    wich one I can find the recovery model for the databases?

    thanks

  • June 2, 2008 at 10:55 am

    #823097

    I ran this against Master:

    select * from sys.databases

  • June 2, 2008 at 10:57 am

    #823098

    thank YOU 🙂

  • June 2, 2008 at 10:58 am

    #823101

    No problem.

    On second thought: You can run it against any of your databases & it should yield the same result.

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

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