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