Database mirroring support also by SQL server 2005 without SP1 RRS feed

  • Question

  • Hi All,

    I get a general question about the feacture "Database Mirroring". Is it support by SQL Server Standard. Edition without SP1?? Of i still need to upgrade the server from SQL Server 2005 to SQL Server 2005 with SP1?

    Another question: are there any problem if the one machine(server) has installed SQL server 2005 Standard edition and the other with "Developer Editon".

    I hope some one can answer my question. Thanks anyway!



    Wednesday, September 27, 2006 3:29 PM


All replies

  • Yes, it's supported in SQL server 2005 standard edition. But by default it's disable. you must specify the trace flag 1400 as a startup parameter. Please refer http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=423000&SiteId=1 for more detail.

    There should not be problem if one server is "standard edition" and other one is "developer edition".

    Wednesday, September 27, 2006 11:57 PM
  • Hi All,

    Anyone know or i still to install the SQL Server 2005 SP 1 first before i can use the feature "Database Mirroring"?

    Best regards,


    Thursday, September 28, 2006 7:31 AM
  • I believe your question was answered by the above post

    YES, you can do database mirroring in SQL2005, with or without SP1 (need to set trace flag 1400)


    For your other question, mirroring between STD and DEV edition

    This post should help, even though it's between STD and ENT (DEV IS Enterprise edition)


    Thursday, September 28, 2006 7:29 PM
  • In non-SP1, Database mirroring exists, but it is not supported. What that means is that you are using it at your own risk. If it blows up and deletes allof your data, MS won't help you unless you are running SP1.


    Wednesday, October 25, 2006 11:53 PM