Close

high availability

SQL Server Mirroring

This post will describe steps for setting up SQL Server 2012 mirroring. Note: Microsoft recommends focusing on Always On for high availability as database mirroring will most likely be removed from MS SQL Server in future. Setup – on my laptop [called K9] with 3 SQL instances, default [primary], MIR instance and the secondary/target is […]

Read More

Database Mirroring

Prefered long term solution for this suggested by Microsoft is using AlwaysOn High Availablilty. T-SQL Code for mirroring [note the port numbers have to be different. /****** Object: Endpoint [mirroring] on Server1 Script Date: 4/27/2014 3:32:37 AM ******/ CREATE ENDPOINT [mirroring] STATE=STARTED AS TCP (LISTENER_PORT = 7575, LISTENER_IP = ALL) FOR DATA_MIRRORING (ROLE = PARTNER, […]

Read More