db mirroring mode change by?

  • My db mirroring mode was changed from async to sync...

    How can i know when it was changed and probably by whom.

    Error logs..?

    any tables..?

    Thanks

  • either a database owner or a sysadmin can change this, how many people hold this role in your organisation?

    The state change is logged in the default trace so try having a look to see if there is any information there.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • sadly, we do not retain older trace files 🙁

    Yea, we have many sa on the system.. thats the need... any other logging done somewhere..

  • if you believe someone is changing mirroring modes without authorisation then run a smal server side trace to capture these events, this will help identify who is making the change

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • Thanks.

    Yes, we are now planning to have server side trace.

    However, just wandering if we can somehow find who did it last time.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply