Post reply

witness server

  • August 11, 2016 at 10:00 pm

    #320603

    Hi All,

    I am going to set up a witness server to monitor principal and Mirror server using sql 2008.

    Should I restore the databases in witness server?

    I feel I shouldn’t but not so sure .

    Any consideration for this server ?

    Any feedback are much appreciated

    Thank you

  • August 15, 2016 at 7:53 am

    #1895451

    Hi, the only role of a witness server in a Mirroring configuration is to determine automatic failover, so, no, you would not need to restore your database(s) onto the witness server, only the secondary during the mirroring setup. As far as the requirements of a witness, Microsoft says - A witness can run on any reliable computer system that supports the edition of SQL Server you are running. Every server instance that is used as a witness should correspond to the minimum configuration that is required for the SQL Server version that you are running.

  • August 15, 2016 at 3:02 pm

    #1895524

    WhiteLotus (8/11/2016)

    Should I restore the databases in witness server?

    No.

    The witness is there solely to check whether it can see the principle or mirror to decide whether to failover the mirroring DB. Nothing else. It can be running SQL Express even, doesn't have to have any databases on it.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 22, 2016 at 7:56 pm

    #1896789

    Thanks guys for the feed back . Much appreciated !

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

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