Post reply

configure mirroring

  • July 17, 2015 at 1:35 am

    #309942

    we have two server & i am going to configure mirroring can u pls tell me how to make principal as a witness in mirroring

  • July 17, 2015 at 1:43 am

    #1813176

    There are many tutorials online. Please research.

  • July 17, 2015 at 1:46 am

    #1813178

    can i make principal as a witness...I dont know ...pls give me link where i found..i am in trouble..pls help

  • July 17, 2015 at 2:49 am

    #1813190

    You can, and there are plenty of tutorials and how-to articles online. Google should turn up piles.

    That said, should you be doing that? Do you understand what that will mean for failover? Are you happy with the resultant failover behaviours?

    Also, why are you configuring mirroring with SQL 2014, when it's been deprecated for two versions and may well be removed in a couple of versions?

    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

  • July 17, 2015 at 2:55 am

    #1813191

    i am configuring in sql server 2008

    and my frnd pls dont give me such type of solution

  • July 17, 2015 at 3:09 am

    #1813198

    In future please post in the correct forum section. Posting a 2008 question in the 2014 forum means you'll get answers relevant for SQL 2014

    The very first hit from google for 'Configure database mirroring' is the MSDN entry which walks you through the set up step-by-step.

    https://msdn.microsoft.com/en-us/library/ms190941.aspx

    Part way down there's a piece on adding a witness. It's the same whether the witness is the publisher, the mirror or some other SQL instance

    I'm not here to do your job for you. At least read the documentation before you post on the forums. We're happy to help people stuck with specific issues, less so with questions that could have been answered with a quick google search.

    http://www.sqlskills.com/blogs/paul/rtfm-no-seriously-r-t-f-m-then-ask-your-question/

    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

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

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