database mirroring.

Hi All,

I am researching database mirroring in sql server 2005.

I came across in multiple places the following paragraph...

" Microsoft support policies do not apply to the database mirroring feature in SQL Server 2005. Database mirroring is currently disabled by default, but may be enabled for evaluation purposes only by using trace flag 1400 as a startup parameter. (For more information about trace flags, see Trace Flags (Transact-SQL).) Database mirroring should not be used in production environments, and Microsoft support services will not support databases or applications that use database mirroring. Database mirroring documentation is included in SQL Server 2005 for evaluation purposes only, and the Documentation Policy for SQL Server 2005 Support and Upgrade does not apply to the database mirroring documentation. "

I would not be worried if i did not find this in real microsoft documentation and the BOL!!

Would somebody please verify or discredit these statements?

thanks!

Hi Shelly,

Database Mirroring is fully supported with SQL Server 2005 SP1. Before SP1 it was not supported.

So once you have installed SP1 for SQL 2005, you should be able to use database mirroring without trace falg 1400.

regards

Jag

|||Jag is correct. Database Mirroring is fully supported by Microsoft as of SP1. It works very well, in my experience.