Enabling Database Mirroring in SQL Server 2005 for Testing

  • Article

If you want to start testing database mirroring in SQL Server 2005, you will need to enable a trace flag on your SQL Server 2005 instance.  To do so, you will need to modify the start-up flags for the SQL Server executable and add the following option:  -T1400 .  Please note that the -T is case sensitive and must be uppercase. 

 

To add this start-up option to the SQL Server 2005 executable, you can use the SQL Server Configuration Manager tool from the Configuration Tools program sub-group in the SQL Server 2005 program group,  Under SQL Server Services, right-click on the SQL Server service you want to enable Database Mirroring on and then on the Advanced tab and modify the Startup Parameters value to add -T1400 to the list of parameters.  Make sure to separate any new parameters by a semi-colon (;).  Stop and re-start your SQL Server service to enable this option. 

 

After doing so you will be able to configure database mirroring for any of your user databases by right-clicking on the database or by using a script.