August 25, 2011 at 12:40 am
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
August 25, 2011 at 4:01 am
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" 😉
August 26, 2011 at 1:05 am
sadly, we do not retain older trace files 🙁
Yea, we have many sa on the system.. thats the need... any other logging done somewhere..
August 26, 2011 at 3:01 am
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" 😉
August 26, 2011 at 3:10 am
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