Post reply

Compare setting beetween two db

  • July 14, 2009 at 7:56 am

    #136514

    How can I compare settings between 2 databases. Thank you

  • July 14, 2009 at 8:11 am

    #1024420

    Query the sys.databases system table in master.

  • July 14, 2009 at 8:34 am

    #1024432

    Thank you, Is anything else I should be checking for setting databases? I checked in sysdatabases and I found that everything is the same accept status, db 1 = 0 and db 2 = 16. What is the difference?

  • July 14, 2009 at 8:58 am

    #1024452

    status 16 indicates that torn page detection is enabled for that DB.If you are using 2005 use sys.databases instead of sysdatabases.It has more info.

  • July 14, 2009 at 9:05 am

    #1024465

    Do you know what 0 means, I have bunch of db like that, I am using 2000, but running from 2005.

  • July 14, 2009 at 9:06 am

    #1024471

    There is a seperate thread running for status of dbs. Please post your replies Here


    Pradeep Singh

Viewing 6 posts - 1 through 5 (of 5 total)

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