A SQL Server 2005 High Safety DB Mirroring session synchronously transfers transactions from the primary DB to the mirroring DB and then with the help of a witness server supports automatic fail over from the primary to the mirror is the primary becomes unavailable. All the primary, mirror and witness nodes all keep an eye [...]
Tag Archives: ports
Port madness
Monday, February 25, 2008
Update: I have posted some more information on connecting to the DAC here.
Playing with ports in SQL Server should be one of the simplest things around. The other day I was studying for the next exam (MCDBA Upgrade) and read this about the ports the server uses…
“If enabled, the default instance of the SQL [...]