How To Set A Witness Server To Database Mirroring?

1.	How To Set A Witness Server To Database Mirroring?
Answer» SSMS:- Right CLICK on Principal Database > TASKS > Mirror > Click on CONFIGURE Security > PROVIDE the End point for Witness server > Click oK T-SQL:- ALTER DATABASE Adventure WORKS SET WITNESS = 'TCP://prasad.local:5024' (Do this from the Principal Server) SSMS:- Right Click on Principal Database > Tasks > Mirror > Click on Configure Security > Provide the End point for Witness server > Click oK T-SQL:- ALTER DATABASE Adventure Works SET WITNESS = 'TCP://prasad.local:5024' (Do this from the Principal Server)

Answer»

SSMS:- Right CLICK on Principal Database > TASKS > Mirror > Click on CONFIGURE Security > PROVIDE the End point for Witness server > Click oK

T-SQL:- ALTER DATABASE Adventure WORKS SET WITNESS = 'TCP://prasad.local:5024' (Do this from the Principal Server)

SSMS:- Right Click on Principal Database > Tasks > Mirror > Click on Configure Security > Provide the End point for Witness server > Click oK

T-SQL:- ALTER DATABASE Adventure Works SET WITNESS = 'TCP://prasad.local:5024' (Do this from the Principal Server)

Discussion