locked
Server Mirroring in SQL Server 2008 R2 RRS feed

  • Question

  • Hi everyone, Is it possible to do Server mirroring in SQL Server 2008 R2 instead of database mirroring?If possible how?

     

    Thanks!

    Coon.


    • Edited by MamaMaya Friday, September 23, 2011 2:34 AM
    Friday, September 23, 2011 2:17 AM

Answers

  • Hello,

    Dont really understand what you meant by Server Mirroring,but can recommend what will be possible and best situation for a HA /DR strategy.

    You can setup a Windows Cluster between two servers which will ensure that Server level problems will be taken care,ie Incase your Node A failed because of Memory block issues,then Node B can serve the SQL resource.

    Incase you want database level DR solution,then you should have Database Mirroring setup.

    Hope this helps.

    Thank you,

     


    Thank you, Anup| Forum Support| If you think my suggestion is useful, please rate it as helpful. If it has helped you to resolve the problem, please Mark it as Answer.
    Friday, September 23, 2011 6:25 PM
  • if you want to implement HA on server level you should set clustering environment. 

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


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    • Proposed as answer by Peja Tao Monday, September 26, 2011 5:33 AM
    • Marked as answer by Peja Tao Thursday, October 6, 2011 9:11 AM
    Sunday, September 25, 2011 6:24 AM

All replies

  • Hello,

    Dont really understand what you meant by Server Mirroring,but can recommend what will be possible and best situation for a HA /DR strategy.

    You can setup a Windows Cluster between two servers which will ensure that Server level problems will be taken care,ie Incase your Node A failed because of Memory block issues,then Node B can serve the SQL resource.

    Incase you want database level DR solution,then you should have Database Mirroring setup.

    Hope this helps.

    Thank you,

     


    Thank you, Anup| Forum Support| If you think my suggestion is useful, please rate it as helpful. If it has helped you to resolve the problem, please Mark it as Answer.
    Friday, September 23, 2011 6:25 PM
  • if you want to implement HA on server level you should set clustering environment. 

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


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    • Proposed as answer by Peja Tao Monday, September 26, 2011 5:33 AM
    • Marked as answer by Peja Tao Thursday, October 6, 2011 9:11 AM
    Sunday, September 25, 2011 6:24 AM
  • if you want to implement HA on server level you should set clustering environment. 

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


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Sunday, September 25, 2011 6:24 AM
  • I agree with Anup that using SQL Server failover clustering for server-level HA (you only have one copy of the database). In addition, the next version of SQL Server, Denali which has a new AlwaysOn feature that you can create mirroring group with multiple databases. Check blog post: http://www.brentozar.com/archive/2010/11/sql-server-denali-database-mirroring-rocks/.
    Best Regards
    Alex Feng

    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    Tuesday, September 27, 2011 10:23 AM