Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.