Browse by Tags

All Tags » mirroring (RSS)

Transferring aliases from Sql Server Configuration manager between machines

Ever since I have been working with Named Sql Instances using static ports, it has been a pain. Connection strings need to be recoded to include the port syntax: <ServerName>[\InstanceName],<Port> <IP Address>[\InstanceName],<Port>...
Posted by blakmk

Sql Server Consolidation and Configuration Part 2 Network

An often neglected part of Consolidation is the network configuration of a server. If you have mirroring set up this is particuarly important because the network throughput can be in the same magnitude of the transaction log throughput. Generally if I...
Posted by blakmk | 2 comment(s)
Filed under: ,

Using DNS aliases with Database Mirroring

I recently found myself having to failover a database mirror due to hardware issues. I was pretty horified that to do this, one of the applications had to be resinstalled because it did not support the failover partner parameter in the connection string...