How To Remove A Witness Server From Database Mirroring?

1.	How To Remove A Witness Server From Database Mirroring?
Answer» SSMS:- RIGHT Click on PRINCIPAL Database > Tasks > Mirror > Remove TCP address from the WITNESS > Click oK. T-SQL:- ALTER DATABASE Adventure WORKS SET WITNESS OFF. SSMS:- Right Click on Principal Database > Tasks > Mirror > Remove TCP address from the Witness > Click oK. T-SQL:- ALTER DATABASE Adventure Works SET WITNESS OFF.

Answer»

SSMS:- RIGHT Click on PRINCIPAL Database > Tasks > Mirror > Remove TCP address from the WITNESS > Click oK.

T-SQL:- ALTER DATABASE Adventure WORKS SET WITNESS OFF.

SSMS:- Right Click on Principal Database > Tasks > Mirror > Remove TCP address from the Witness > Click oK.

T-SQL:- ALTER DATABASE Adventure Works SET WITNESS OFF.

Discussion