Post reply

SQL 2008 Mirroring

  • December 9, 2009 at 9:34 am

    #207051

    Hi,

    I already have a SQL 2005 mirror that uses SQL 2005 Express Edition as it's Witness and all is working fine. I now have a new SQL 2008 database that I have mirrored, can I use my SQL 2005 Express Edition as a Witness for this mirror also.

    Each time I try to add it as a Witness I get the following error

    The ALTER DATABASE command could not be sent to the remote server instance 'TCP://IN-WIT:5022'. The database mirroring configuration was not changed. Verify that the server is connected, and try again.

    I can confirm I can telnet to port 5022 on the Witness server - it is not network related.

    Regards,

    Jo

  • December 9, 2009 at 10:14 am

    #1090014

    BOL indicates 2005 express edition is supported w/ 2008 -

    http://msdn.microsoft.com/en-us/library/ms175191.aspx

    I came across this on social - may offer some assistance in troubleshooting the issue -

    http://social.msdn.microsoft.com/Forums/en/sqldatabasemirroring/thread/611d4c49-c37e-42de-b1e0-7db7ece718f5

    Tommy

    Follow @sqlscribe

  • December 10, 2009 at 4:50 am

    #1090449

    Hi,

    Thanks for the response - all systems are part of the same domain and all use the same domain login for sql services.

    I have checked and checked again the network setup relating to hostnames, dns, fqdn, etc.

    As I already have a SQL 2005 mirror using this SQL 2005 Express Instance as it's Witness, would there be any conflict using it again as a Witness for my new SQL 2008 mirror?

    Thanks!

  • December 10, 2009 at 8:04 am

    #1090575

    None to the best of my knowledge; a witness can monitor multiple mirrored sessions.

    Tommy

    Follow @sqlscribe

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

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