Thursday, February 9, 2012

Accessing mirrored databases in SqlServer 2005

Using the new sqlserver 2005 mirroring, can client connections be made to the non-principal database for, say, reporting purposes? Does this affect the failover?

Thanks

For reporting only run with safety off and no witness. Either one is enough to disable auto failover, but quorum (2 of 3) is required to run with safety on so with no witness both systems must be up to update the principal server. Safety off allows running with the mirror down and no witness. To use the mirror as a reporting server you can create database snapshots on an active mirror. This allows point in time read only access to the database.

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

No comments:

Post a Comment