none
how to Mirrorring Sql Server Dayabase? RRS feed

  • Question

  • I have Sql Server 2005 Express in that How can i do DB Mirroring?
    • Moved by Yi-Lun Luo Monday, September 7, 2009 7:14 AM Off topic. (From:Windows Azure)
    Monday, September 7, 2009 6:40 AM

Answers

  • Hi Senthil,
    Refer to the link below.

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

    Before you use the Mirroring page to configure database mirroring, ensure that the following requirements have been met:

    • The principal and mirror server instances must be running the same edition of SQL Server-either Standard Edition or Enterprise Edition. Also, we strongly recommend that they run on comparable systems that can handle identical workloads.
      Note:
      The witness server instance can run on SQL Server Standard Edition, Enterprise Edition, Workgroup Edition, or Express Edition.

    So, the answer is no. Unless you use it as witness server.

    Let us know if you have any further questions on this.

    Please Vote & "Mark As Answer" if this post is helpful to you.

    Cheers
    Bikash Dash
    MCDBA/MCITP

    • Proposed as answer by RHenry Wednesday, September 9, 2009 5:40 AM
    • Marked as answer by Mark Han [MSFT] Tuesday, September 15, 2009 2:20 AM
    Wednesday, September 9, 2009 5:09 AM

All replies

  • If you're using Windows Azure, you can use SQL Azure as your database. But it seems that you're working with an on-premise SQL Server? Then please ask your question on the SQL Server forum. By the way, if you're working with SQL Azure, you don't need to worry about mirroring and other management tasks. The management of the database server is Microsoft's job, not your job. This is a benifit of the cloud. :)
    Lante, shanaolanxing This posting is provided "AS IS" with no warranties, and confers no rights.
    Monday, September 7, 2009 7:13 AM
  • SQL express editions can only be used a WITNESS in a mirroring configuration. They cant be a pricipal or a mirror server.

    Please refer the table at the link http://technet.microsoft.com/en-us/library/cc917680.aspx


    Thanks, Leks
    Monday, September 7, 2009 9:33 PM
    Answerer
  • Hi

    about how to create a database mirroring, there is a link for you:http://msdn.microsoft.com/en-us/library/ms189047.aspx

    for more information about database mirroring:http://technet.microsoft.com/en-us/library/cc917680.aspx

    Regards
    Wednesday, September 9, 2009 4:52 AM
  • Hi Senthil,
    Refer to the link below.

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

    Before you use the Mirroring page to configure database mirroring, ensure that the following requirements have been met:

    • The principal and mirror server instances must be running the same edition of SQL Server-either Standard Edition or Enterprise Edition. Also, we strongly recommend that they run on comparable systems that can handle identical workloads.
      Note:
      The witness server instance can run on SQL Server Standard Edition, Enterprise Edition, Workgroup Edition, or Express Edition.

    So, the answer is no. Unless you use it as witness server.

    Let us know if you have any further questions on this.

    Please Vote & "Mark As Answer" if this post is helpful to you.

    Cheers
    Bikash Dash
    MCDBA/MCITP

    • Proposed as answer by RHenry Wednesday, September 9, 2009 5:40 AM
    • Marked as answer by Mark Han [MSFT] Tuesday, September 15, 2009 2:20 AM
    Wednesday, September 9, 2009 5:09 AM