Database Mirroring Configuration

–step 1
—————————————————————————————————————————–
–On Secondary ( Mirror Server ) ,
–Server_Name2

USE MASTER;
GO
ALTER DATABASE [DB_Name] SET PARTNER = ‘TCP://Server_Name1.domain.com:5022’
GO
—————————————————————————————————————————–

–step 2
—————————————————————————————————————————–
–On Primary (Principal Server) ,
–Server_Name1

USE MASTER;
GO
ALTER DATABASE [DB_Name] SET PARTNER = ‘TCP://Server_Name2.domain.com:5022’
GO
—————————————————————————————————————————–

–step 3
—————————————————————————————————————————–

–Configure Witness (Server_Name3)

ALTER DATABASE [DB_Name] SET WITNESS = ‘TCP://Server_Name3.domain.com:5022’;
GO


Posted

in

,

by

Tags:

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *