none
SQL Server 2008 Mirroring Errors. RRS feed

  • Question

  • Hi All, 

    I try to do mirror sql server 2008 for my project server 2010,so it has error message like that "alter failed for database 'DatabaseName' (Microsoft.SqlServer.Smo)"

    An exception occurred while executing a transact-SQL statement or bath.(Microsoft.SqlServer.ConnectionInfo)

    Neither the partner nor the witness server instance for database "databasename" is available. Reissue the command when at least one of the instances becomes available.(Microsoft SQL Server, Error:1431).

    Please help me ...!

    Thanks and best regard

     


    ------------------------------------------------------------ ---Tola---
    Tuesday, June 7, 2011 10:57 AM

All replies

  • Hi,

    Can you log in to the witness or the mirror server from the principal? Are you sure that the mirroring endpoints are created and started? Is there any port filtering on your network? it may prevent you to use some ports, eg 5022 which is the default port for mirroring.

    I hope it helps.

    J.


    There are 10 type of people. Those who understand binary and those who do not.
    Tuesday, June 7, 2011 1:14 PM
  • also hear some more help to resolve mirroring network issues http://msdn.microsoft.com/en-us/library/ms189127.aspx

     


    http://uk.linkedin.com/in/ramjaddu
    Tuesday, June 7, 2011 4:36 PM
  • Hi,

    I can log to the mirror server, The mirroring endpoints are created and started. And port filtering on my network is 5022.

    It still not work, so what could i do?

    thank for help!

     


    ------------------------------------------------------------ ---Tola---
    Wednesday, June 8, 2011 2:43 AM
  • Can you please run "SELECT * FROM SYS.Database_Mirroring" on all three machines (Principal, Mirror and Witness) and send the output?

    Lucifer

    Wednesday, June 8, 2011 7:19 AM
  • Are you configuring mirror on databases resides on same server? if answer is yes then you should configure endpoints under different ports for principal and mirror servers

    also please check the account under end points configured does it have enough permissions on all servers? also SQL service account has got required permissions .


    http://uk.linkedin.com/in/ramjaddu
    Wednesday, June 8, 2011 9:21 AM
  • I have only two machines(Principal mirror and witness) only.

    The output of mirror servers 

    database ID   Other fields (all)

    1 to 36 NULL

     

    Output for Witness Servers

    Database_ID    other fields(all)

    1 to 11 NULL

     

    Thanks..!


    ------------------------------------------------------------ ---Tola---
    Thursday, June 9, 2011 3:03 AM
  • Hi,

    can you post the result of this query?

    SELECT * FROM sys.database_mirroring_endpoints

    Are you sure that you followed these steps for mirroring configuration? http://technet.microsoft.com/en-us/library/ms179306.aspx

    Thanks,

    J.


    There are 10 type of people. Those who understand binary and those who do not.
    Thursday, June 9, 2011 4:55 AM
  • Hi,

    Maybe it is a networking error from OS and the problem is outside of SQL. Could you please check the SQL ERRORLOG on mirror whether it contain the error like below:
    Error: 1474, Severity: 16, State: 1.
    Database mirroring connection error 2 'DNS lookup failed with error: '11001(No such
    host is known.)'.' for 'TCP://.....net:5022'.

    If yes, the resolution is to add entry for principal FQDN on mirror host file.

    Hope this helps.


    Best Regards,
    Peja

    Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    Thursday, June 9, 2011 6:56 AM
  • Hi,

    I am follow by this links but still not work http://technet.microsoft.com/en-us/library/ff872145.aspx

    Thanks you so much..!


    ------------------------------------------------------------ ---Tola---
    Thursday, June 9, 2011 7:02 AM
  • All fields null on my query looks very much like a configuration problem... No matter how screwed up a connection is there should be a mirroring_partner_name, a mirroring_guid and a mirroring_state filled in the sys.database_mirroring view for all databases that have mirroring enabled. You should try setting up mirroring only with Principal and Mirror, without using a witness. I would be interested to see what error this brings up.
    Thursday, June 9, 2011 8:15 AM
  • Can you telnet on port 5022 from principal to mirror and other way round?

    also can you please check windows error log / SQL error logs on all principal, mirror and witness for any errors?

    Can you please post output of below query from principal?

     

    select
    db_name(database_ID) DBName
    ,Mirroring_state_desc
    ,Mirroring_role_desc
    ,Mirroring_safety_level_Desc
    ,Mirroring_partner_Instance
    ,mirroring_witness_name
    ,Mirroring_witness_state_desc
    from sys.database_mirroring
    Where db_name(database_ID) = <DBNAME> ----- here your dbname


    http://uk.linkedin.com/in/ramjaddu
    Thursday, June 9, 2011 10:28 AM
  • You need to break the mirroring by using SET PARTNER OFF; and then setup the mirroring as per your document for Project server.

     


    Satya SKJ, SQL Server MVP www.sqlserver-qa.net [knowledge sharing network]
    Get knowledge sharing network feeds by Email
    Wednesday, June 15, 2011 9:45 AM
  • Hi Tola,

    Please configure you database engine services with POWER NETWORK USER a/c as SQL 28 support for domain network a/c only , this error comes due endpoint doesn't listen properly with configuring local system or admin a/c.

     

     

     

    Friday, July 1, 2011 10:59 AM