Mirror Status Change

How can I determine when the status of a mirrored database on a server
changes from Principal to Mirrored?
Also, can I determine who or what caused the status to change?
Hi
SELECT * FROM sys.database_mirroring;
"BigSam" <BigSam@.discussions.microsoft.com> wrote in message
news:49F51B2A-1AA4-4BF5-ADC4-2C5C2E629FB4@.microsoft.com...
> How can I determine when the status of a mirrored database on a server
> changes from Principal to Mirrored?
> Also, can I determine who or what caused the status to change?
|||This shows the current status, but not who, what, when, how, or why it changed.
"Uri Dimant" wrote:

> Hi
> SELECT * FROM sys.database_mirroring;
>
> "BigSam" <BigSam@.discussions.microsoft.com> wrote in message
> news:49F51B2A-1AA4-4BF5-ADC4-2C5C2E629FB4@.microsoft.com...
>
>
|||You can see information about the database mirroring state change in the
error log.
Database mirroring is active with database 'Database1' as the principal copy.
Database mirroring is active with database 'Database1' as the mirror copy.
Another option is to capture the Database Mirroring State Change Event Class
with SQL Trace or Event Notifications.
http://msdn2.microsoft.com/en-us/library/ms191502.aspx
Ola Hallengren
http://ola.hallengren.com
"BigSam" wrote:
[vbcol=seagreen]
> This shows the current status, but not who, what, when, how, or why it changed.
> "Uri Dimant" wrote: