Database Mirroring

Hi,

Would anyone know if database mirroring with SQL Server 2005 is ready for public use or if it's still being tested. Has anyone been successful at setting it up?

Thanks,

Sylvie

It is definitely ready for use. In the versions of SQL Server prior to Service Pack 1, you had to enable a trace flag, but that's all cleared up in SP1. You can find out more about it here, along with the steps to set it up:

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

If you want to try the client auto-failover, open this page and search for "mirror":

http://download.microsoft.com/download/d/8/6/d865cf0c-c44b-401b-b426-b3bf5c628112/SQLServerDatabasesAndSamplesOverview.htm#MirroringFailover

It's being used in production systems around the world.

Buck Woody