SQL Server Performance

mirroring with out witness server

Discussion in 'SQL Server 2005 Database Mirroring' started by shashank sharma, Jul 31, 2006.

  1. shashank sharma New Member

    hi all

    we are workin on mirroring ......and getting the same error as rest of people
    we are doing mirroring with out witness server is that a reson for these three errors
    errors are.........> :..>

    Alter failed for Database 'KQDB', (Microsoft SqlServer.Smo)

    :..>An exception occured while executing a Transact-SQL statement or batch
    [Microsoft SqlServer.Connection.info]

    :..>Database mirroring Transport is disabled in the endpoint configuration.
    [Microsft SQL Server,Error: 1486]

    if any one has done sucessfully can i plz have the exsact steps

    & one more doubt which one is more usefull and less prone to comman errors sql server management studio or T-sql for performing mirroring activity.

    thanks
    shashank jr,dba



    loosing ur love is loosing ur life
  2. satya Moderator

    Why not install Witness server on a SQL Express edition?
    One of the MS forums refers:
    quote:
    You don't need the trace flag if you install SP1 which has now released.

    Otherwise if SP1 isn't yet an option (which it really should be if you want to use db mirroring), you can add -T1400 as a startup parameter via the SQL Configuration Manager, properties of the SQL Server service -> advanced tab ->Startup Parameters.

    it's not particularly well indexed or cross-referenced but BOL has details here :

    ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/c82d19e5-5557-4235-9a70-37983607a1fd.htm

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
  3. shashank sharma New Member

    hi

    i have only two sql 2005 servers than wat shall i do........?

    thanks
    shashank jr.dba

    loosing ur love is loosing ur life
  4. satya Moderator

    You can install SQL Express which is free to use as a witness, which is documented in BOL I think.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
  5. shashank sharma New Member

    thank u i'll for sure do that

    loosing ur love is loosing ur life
  6. Anonymous New Member

    theres no need of witness as a part of mirroring... its role is just to failover principal to mirror server in case if there is any.. if witness is not configured then failover can be intiated manually
    Sidh

    next2none is what others feel about the maverick
  7. satya Moderator

    quote:When you use database mirroring in high-availability mode, the process of determining a failover is based on the network connection. If there is a problem with the network, mirroring will fail over or deny access to the database because of the quorum requirement. Although mirroring has acted correctly, not having access may surprise customers, because with an ordinary stand-alone computer, the database would still be served.
    Though DM without witness is possible that is another type of Synchronous mirroring configuration, I wouldn't go that route on a production server environment.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided �AS IS� with no rights for the sake of knowledge sharing.

Share This Page