Database mirroring support also by SQL server 2005 without SP1

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!

Regards,

Pat

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".

|||

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,

Pat

|||

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)

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=730526&SiteID=1

|||

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.