Thanks for the replies,

The issue is more one of needing to know if there is a backup failure so that we can take action fast.. the Issue is with the...

Mirroring Monitor Job Failure

Steps to recreate

ServerDatabaseRole

SERVER_1AdventureWorksPrincipal

SERVER_2AdventureWorksMirror

SERVER_3N/A Witness

1)Create the Database Mirroring Job

Exec sp_dbmmonitoraddmonitoring

Set the Log files to be...

UPDATE:

responded with the following

I have just taken the escalation about the case in the subject

--In summary I can write that the issue is the following

Executing...

There are two things to check here

1) @wmi_namespace=N'\\.\root\Microsoft\SqlServer\ServerEvents\MSSQLSERVER',

check that the code is being run against a default instance otherwise the MSSQLSERVER will have to be the instance

2) Check...

However

It may be looking at the Database Mail within SQL Server 2005 as you can include multiple profiles for mail so that each one gets tried until the mail is...

I am currrently looking at Mirroring in a production environment and was considering the options ... here are some thoughts ---- thinking as I type:

For Service Packing SQL Server i...

What I Meant to ask is how is everyone else monitoring their Mirror Configuration and what should I look out for

Andy