locked
is it possible to mirror database in sql server 2005 high protection mode? RRS feed

  • Question

  • is it possible to mirror database in sql server 2005 high protection mode?
    Wednesday, August 25, 2010 5:28 AM

Answers

  • Yes: http://technet.microsoft.com/en-us/library/cc917680.aspx


    Regards Marten Rune Microsoft Certified IT Professional Database Administrator/Developer 2008
    • Marked as answer by Cup Of Life Saturday, October 9, 2010 12:52 PM
    Wednesday, August 25, 2010 5:34 AM
  • Hi,

    You have posted twice for the same question, please see the answer in your other post: http://social.msdn.microsoft.com/Forums/en-US/sqldatabasemirroring/thread/b72378c0-308f-4c34-922c-e044f4ac28ee

    Tom


    Tom Van Zele | Blog | Twitter | LinkedIn
    • Marked as answer by Cup Of Life Saturday, October 9, 2010 12:52 PM
    Wednesday, August 25, 2010 6:03 AM
  • No, there was an option, but not working anymore. Apply SQL Server 2005 SP1 to enable the database mirroring features.
    SKG: Please Marked as Answered, if it resolves your issue.
    • Marked as answer by Cup Of Life Wednesday, August 25, 2010 10:52 AM
    Wednesday, August 25, 2010 10:15 AM
  • As Sudeepta wrote, SP1 or higher. I would recommend SP3 though. It's been out there for over a year and must be considered stabile. So in my opinion apply the latest SP (i e SP3 for SQL2005) and then enable the db mirroring features.
    Regards Marten Rune Microsoft Certified IT Professional Database Administrator/Developer 2008
    • Proposed as answer by Sudeepta Ganguly Wednesday, August 25, 2010 10:37 AM
    • Marked as answer by Cup Of Life Thursday, September 16, 2010 6:51 AM
    Wednesday, August 25, 2010 10:35 AM
  • HI,

     Its posible, you need to add ;-T1400 flag in the startup parameter of Sql server.

     

    ·         Goto RUN --> Type sqlservermanager.msc

    ·         Right click on SQL Server(instancename) service and click on properties

    ·         Click on Advanced tab

    ·         In the startup parameters enter this ;-T1400 and click on OK

    ·         Restart SQLservices and then try configuring db mirroring

    • Marked as answer by Cup Of Life Saturday, October 9, 2010 12:52 PM
    Wednesday, August 25, 2010 2:08 PM

All replies

  • is it possible to mirror a database in sql server 2005 in high protection mode?  
    Wednesday, August 25, 2010 5:24 AM
  • Yes: http://technet.microsoft.com/en-us/library/cc917680.aspx


    Regards Marten Rune Microsoft Certified IT Professional Database Administrator/Developer 2008
    • Marked as answer by Cup Of Life Saturday, October 9, 2010 12:52 PM
    Wednesday, August 25, 2010 5:34 AM
  • Hi,

    You have posted twice for the same question, please see the answer in your other post: http://social.msdn.microsoft.com/Forums/en-US/sqldatabasemirroring/thread/b72378c0-308f-4c34-922c-e044f4ac28ee

    Tom


    Tom Van Zele | Blog | Twitter | LinkedIn
    • Marked as answer by Cup Of Life Saturday, October 9, 2010 12:52 PM
    Wednesday, August 25, 2010 6:03 AM
  • is it possible in RTM edition?
    Wednesday, August 25, 2010 9:37 AM
  • is it possible in RTM edition?
    Wednesday, August 25, 2010 9:38 AM
  • No, there was an option, but not working anymore. Apply SQL Server 2005 SP1 to enable the database mirroring features.
    SKG: Please Marked as Answered, if it resolves your issue.
    • Marked as answer by Cup Of Life Wednesday, August 25, 2010 10:52 AM
    Wednesday, August 25, 2010 10:15 AM
  • As Sudeepta wrote, SP1 or higher. I would recommend SP3 though. It's been out there for over a year and must be considered stabile. So in my opinion apply the latest SP (i e SP3 for SQL2005) and then enable the db mirroring features.
    Regards Marten Rune Microsoft Certified IT Professional Database Administrator/Developer 2008
    • Proposed as answer by Sudeepta Ganguly Wednesday, August 25, 2010 10:37 AM
    • Marked as answer by Cup Of Life Thursday, September 16, 2010 6:51 AM
    Wednesday, August 25, 2010 10:35 AM
  • HI,

     Its posible, you need to add ;-T1400 flag in the startup parameter of Sql server.

     

    ·         Goto RUN --> Type sqlservermanager.msc

    ·         Right click on SQL Server(instancename) service and click on properties

    ·         Click on Advanced tab

    ·         In the startup parameters enter this ;-T1400 and click on OK

    ·         Restart SQLservices and then try configuring db mirroring

    • Marked as answer by Cup Of Life Saturday, October 9, 2010 12:52 PM
    Wednesday, August 25, 2010 2:08 PM