Database mirroring question

08-12-2007, 07:01 AM

I Posted this in SQL Server general and it was suggested I move it here.
Hello,
SQL Server 2005 SP1 SE on WINDOWS 2003 sp1 both principal and mirror
SQL Serverver Express SP1 on WINDOWS 2003 sp1 Witness
In mirror monitoring witness indicates disconected from mirror.
All else is green.
Can ping witness from mirror and connect via MSSMS.
No errors in Witness SQL server errorlog.
What can I do to debug this? I have drilled into the status and I do not
see any errors. I kinda assumed I there is a connectivity problem. Any
ideas on how to debug/resolve it?

08-12-2007, 07:01 AM	#1
Joe Guest Posts: n/a	Database mirroring question I Posted this in SQL Server general and it was suggested I move it here. Hello, SQL Server 2005 SP1 SE on WINDOWS 2003 sp1 both principal and mirror SQL Serverver Express SP1 on WINDOWS 2003 sp1 Witness In mirror monitoring witness indicates disconected from mirror. All else is green. Can ping witness from mirror and connect via MSSMS. No errors in Witness SQL server errorlog. What can I do to debug this? I have drilled into the status and I do not see any errors. I kinda assumed I there is a connectivity problem. Any ideas on how to debug/resolve it?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

New To Site?	Need Help?
Register to Participate Meet our Staff Refer Forum Rules Contact Us	Frequently Asked Questions Did you forget your password?

Database mirroring question

Microsoft SQL Server