Which Trace Flag Is Used In Mirroring?

1.	Which Trace Flag Is Used In Mirroring?
Answer» Trace flags are used to temporarily set specific server characteristics or to switch off/on a particular behavior. 1400 Trace flag is used in mirroring. To set trace flag for Database mirroring:- Configuration MANAGER > Right CLICK on server instance > PROPERTIES > Advanced tab > Startup parameters > -t1400 (ADD)

Answer»

Trace flags are used to temporarily set specific server characteristics or to switch off/on a particular behavior. 1400 Trace flag is used in mirroring.
To set trace flag for Database mirroring:- Configuration MANAGER > Right CLICK on server instance > PROPERTIES > Advanced tab > Startup parameters > -t1400 (ADD)

Discussion