locked
sql database mirroring, different version RRS feed

  • Question

  • can i use different version of sql server for database mirroring.

    let say, principle is sql 2008r2 and mirror is sql 2012.

    witness is server sql 2008r2?

    all of them are standard edition.

    Friday, May 31, 2013 6:37 AM

Answers

  • NO Database mirroring Requires same editions of SQL Server , it is not possible

    Ramesh Babu Vavilla MCTS,MSBI

    • Proposed as answer by Fanny Liu Monday, June 3, 2013 8:45 AM
    • Marked as answer by Fanny Liu Friday, June 7, 2013 7:05 AM
    Friday, May 31, 2013 6:45 AM
  • Adding few more info to that of Babu response ..

    Prerequisites

    Before you can set up database mirroring, you must perform the following:

    •For a new mirroring session to be established, the partners and the witness, if any, must be running on the same version of SQL Server.

    •Make sure that the two partners, that is the principal server and mirror server, are running the same edition of Microsoft SQL Server. Database mirroring partners are supported only by SQL Server 2005 Standard and later versions and by SQL Server 2005 Enterprise Edition and later versions. Asynchronous database mirroring (high-performance mode) is supported only by SQL Server 2005 Enterprise Edition and later versions.

    Refer to following MSDN article .. The above information is provided from the same link ..
    http://blogs.msdn.com/b/ialonso/archive/2011/11/09/never-ever-set-up-a-database-mirroring-session-across-different-sql-server-editions-sku.aspx

    -----------------------------------
    Thanks,Suhas Vallala

     

    • Proposed as answer by Fanny Liu Monday, June 3, 2013 8:45 AM
    • Marked as answer by Fanny Liu Friday, June 7, 2013 7:05 AM
    Friday, May 31, 2013 8:09 AM

All replies

  • NO Database mirroring Requires same editions of SQL Server , it is not possible

    Ramesh Babu Vavilla MCTS,MSBI

    • Proposed as answer by Fanny Liu Monday, June 3, 2013 8:45 AM
    • Marked as answer by Fanny Liu Friday, June 7, 2013 7:05 AM
    Friday, May 31, 2013 6:45 AM
  • Adding few more info to that of Babu response ..

    Prerequisites

    Before you can set up database mirroring, you must perform the following:

    •For a new mirroring session to be established, the partners and the witness, if any, must be running on the same version of SQL Server.

    •Make sure that the two partners, that is the principal server and mirror server, are running the same edition of Microsoft SQL Server. Database mirroring partners are supported only by SQL Server 2005 Standard and later versions and by SQL Server 2005 Enterprise Edition and later versions. Asynchronous database mirroring (high-performance mode) is supported only by SQL Server 2005 Enterprise Edition and later versions.

    Refer to following MSDN article .. The above information is provided from the same link ..
    http://blogs.msdn.com/b/ialonso/archive/2011/11/09/never-ever-set-up-a-database-mirroring-session-across-different-sql-server-editions-sku.aspx

    -----------------------------------
    Thanks,Suhas Vallala

     

    • Proposed as answer by Fanny Liu Monday, June 3, 2013 8:45 AM
    • Marked as answer by Fanny Liu Friday, June 7, 2013 7:05 AM
    Friday, May 31, 2013 8:09 AM
  • thanks
    Friday, June 7, 2013 7:15 AM