SQL Server Performance

db mirroring error 1418

Discussion in 'SQL Server 2005 Database Mirroring' started by ramasubbup, Jun 9, 2006.

Page 1 of 2

  1. ramasubbup New Member

    I am getting the following error when I run the command

    ALTER DATABASE mirroring
    SET PARTNER =
    'TCP://ltihp00460.cts.com:5022'


    Msg 1418, Level 16, State 1, Line 1
    The server network address "TCP://ltihp00460.cts.com:5022" can not be reached or does not exist. Check the network address name and reissue the command.

    I ensured that

    1. TCP protocol is enabled

    2. Am able to ping both the servers

    3. Both the server's sql services are running under same domain account
    and this account is a part of local administrator

    4. checked the ports using netstat

    Thanks for any help


    ramasubbup, Jun 9, 2006
    #2

  2. satya Moderator

    satya, Jun 9, 2006
    #2

  3. dineshasanka Moderator


    Take a look at the issues/steps outlined to troubleshoot error 1418 and mirroring in the following MSDN article:

    http://msdn2.microsoft.com/en-us/library/ms189127.aspx

    Specifically check the points under the topic 'Interpreting Error Message 1418'...


    ----------------------------------------
    http://dineshasanka.blogspot.com/
    dineshasanka, Jun 9, 2006
    #2

  4. ramasubbup New Member

    Thanks for your replies...
    This is the first time i am trying to test the mirroring feature.
    I will go thro' the sites you have mentioned and update you

    ramasubbup, Jun 9, 2006
    #2

  5. satya Moderator

    I would suggest to refer thru books online for more information on setting up Database mirroring.

    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.
    satya, Jun 9, 2006
    #2

  6. ramasubbup New Member

    I am getting the error

    1416 database 'xyz' is not configured for database mirroring

    I don't see much info on how to solve this one.
    anyone faced this same issue before?
    ramasubbup, Jun 12, 2006
    #2

  7. satya Moderator

    Whats wrong or what not is available from the above links, books online states the issue to resolve the error 1418.

    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.
    satya, Jun 12, 2006
    #2

  8. ramasubbup New Member

    YES YES YES

    Its works fine.
    The faults which I did...

    1. I have restored the database from principal to mirror with RECOVERY

    Resolution:
    Restore the database with NORECOVERY option.
    After that restore, restore the transaction log atleast once from principal to mirror
    with NORECOVERY.
    The important stuff is that take separate backup files for database and log
    (don't append to the same backup medium)



    Thanks a ton to sathya and dineshasanka




    ramasubbup, Jun 13, 2006
    #2

  9. alan328 New Member

    alan328, Nov 9, 2007
    #3

  10. Akthar New Member

    is Sp 2 a must for DB Mirroring?
    Akthar, Dec 6, 2007
    #4

  11. Christopher61 New Member

    Okay this is making me nuts... I have a couple of questions:
    1. do all the servers have to have the same system account?
    2. Do you have to restore at least one log backup?
    -chris
    Christopher61, Aug 7, 2008
    #5

  12. satya Moderator

    Welcome to the forums.
    Do you have similar problems as per above?
    If not then for your questions, (1) if the both servers located on differnent domains/network then yes the account used for SQL Server services should be the same in terms of password too.
    For (2) you must restore the latest database backup in order to initiate the mirroring.
    satya, Aug 7, 2008
    #6

  13. Christopher61 New Member

    Hi and I am glad to be here.
    Yes I am having the same error that he process cannot connect to my mirror instance. I have followed the following process:
    1. set my principal DB to full recovery
    2. Did a full backup and restored to my mirror instance with no recovery
    3. did a transaction log backup and restored to my mirror DB with no recovery
    3. configured the security with no errors
    4. tried to start mirroring and it failed the the 1418 error.
    What am I doing wrong???
    -chris
    Christopher61, Aug 7, 2008
    #7

  14. satya Moderator

    2. Did a full backup and restored to my mirror instance with no recovery
    3. did a transaction log backup and restored to my mirror DB with no recovery
    How come you can do another log backup when full backup has been restore WITH NORECOVERY option?
    satya, Aug 7, 2008
    #8

  15. Christopher61 New Member

    I thought that was what I was supposed to do...that is what the book said.
    So should I recreate my DB with a full backup and NOT do the log restore?
    Christopher61, Aug 7, 2008
    #9

  16. Arash Moradabadi New Member

    Arash Moradabadi, Sep 5, 2011
    #16

  17. Luis Martin Moderator

    Arash
    Welcome to the forum!!
    Thanks for you collaboration.
    Please always check the date. This thread is 3 years old:).
    Luis Martin, Sep 7, 2011
    #17

  18. Arash Moradabadi New Member

    Dear Luis
    I knew it but I've left this message for whom that recently looking for the solution as i did
    Mirroring was not a matter for me until the day I've left the message (exactly after 3 years of SQL 2008 was born) so i start searching the net and read so many questions and answers and the instruction in URL above was the best. So tried to share it to others.
    By the way so many thanks for replying me and I'll note the date. Next time I'll describe better my meaning and what I'm doing.
    Thank you for sharing science.
    Arash Moradabadi, Sep 7, 2011
    #18

  19. satya Moderator

    Hey Arash ...welcome to the forums.
    First of all appreciate your feedback to the post that you see most useful...thanks.

    Just to avoid any hot-air misunderstanding here...don't take it in other way, by any means your participation of sharing the knowledge will definetly add a value to this site... keep going. :)
    satya, Sep 8, 2011
    #19

  20. Arash Moradabadi New Member

    Hello Satya
    Thank You
    I 'll do my best
    Arash Moradabadi, Sep 8, 2011
    #20
Page 1 of 2

Share This Page