Mirroring failure - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

High Availability (2005)

Mirroring failure

Author

Topic

sqlserverdbam
Yak Posting Veteran

54 Posts

Posted - 2009-04-24 : 15:53:21

I've following details:

Server 1 =Primary server (Physical machine)
Server 2 =Secondary server (Virtual Machine)
SQLSERVER 2005 Version

Database mirroring failed when when we turn off the virtual machine.
Where can I find mirroring log information and reason of failure?

Thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-04-24 : 16:42:19

What do you mean by "failed"?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

sqlserverdbam
Yak Posting Veteran

54 Posts

Posted - 2009-04-27 : 11:11:56

Hi Tara,

I've seen following error mesage.
04/20/2009 07:00:26,spid31s,Unknown,Database mirroring connection error 2 'Connection attempt failed with error: '10061(No connection could be made because the target machine actively refused it.)'.' for 'TCP://webpage.nwa.com:5023'.
04/20/2009 07:00:26,spid31s,Unknown,Error: 1474<c/> Severity: 16<c/> State: 1.
04/20/2009 07:00:26,spid32s,Unknown,Database mirroring is inactive for database 'meis'. This is an informational message only. No user action is required.
04/20/2009 07:00:26,spid27s,Unknown,Database mirroring is inactive for database 'Intranet'. This is an informational message only. No user action is required.
mirroring connection error 4 'An error occurred while receiving data: '10054(An existing connection was forcibly closed by the remote host.)'.' for 'TCP://webpage.nwa.com:5023'.
04/20/2009 07:00:25,spid26s,Unknown,Error: 1474<c/> Severity: 16<c/> State: 1.

Thanks

ahmad.osama
Posting Yak Master

183 Posts

Posted - 2009-04-29 : 06:21:32

quote:
Originally posted by sqlserverdbam

I've following details:

Server 1 =Primary server (Physical machine)
Server 2 =Secondary server (Virtual Machine)
SQLSERVER 2005 Version

Database mirroring failed when when we turn off the virtual machine.
Where can I find mirroring log information and reason of failure?

Thanks

this is just like shutting down the secondary server.....u must have ur server up and running.

Regards,
Ahmad Osama

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources