SQL Server Performance Forum – Threads Archive

How to enable the Database Mirroring in SQL 2005

how to enable database mirroring in sql 2005? i want to konw how to set option on the startup that enables the mirroring feature. Thanks !

Hi,
I believe mirroring was being left out of the initial release… ‘I reject your reality and substitute my own’ – Adam Savage

-T1400 It’s not left out, it’s not supported.

You can enable it by using Trace flag as specified by Mulhall andhttp://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx fyi. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

There is good number of pages written on SQL Database mirroring feature in SQL BOOKS ONLINE under
"database mirroring [SQL Server]" topic: – From SQL Books online: – Important:
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.
Deepak Kumar –This posting is provided â€œAS ISâ€ with NO rights for the sake of knowledge sharing.

Hi , there are some article on DB Mirroring, hope it helps:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnanchor/html/sqlserver.asp AKTHAR

Hi, i have been struggling to get this thing work. Anyway here is how to enable DB Mirroring 1. Start your SQL Server Service with the :-T1400" switch.
In Configuration Manager , Go to properties of the SQL Server Service, in startup parameters add -T1400 at the end of the line, and restart the service. You will that be able to create your endpoints.. Hope this helps AKTHAR

I wonder whether the originator has checked this information or not, as we keep on pounding the links. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>