April 11, 2011 at 9:12 pm
Hi,
Here we have an issue that someone has moved one of the database from older sql server 2005 to newly sp3 patched
sql server 2005, with some tweaking (basically updating its compatibility level) it all works with apps.
However due to the requirement from managerial level, I have to find out who had moved that database from one
server to another ?
Can anyone please tell me how to do so ?
Regards,
Parth
April 13, 2011 at 6:31 am
check the db owner. If they didn't change it, and if they were windows authenticated, you should see their identity. Depending on how they moved it, you might get lucky.
Leonard
April 13, 2011 at 4:47 pm
Thanks Irut, for your prompt response. 🙂
I have already checked the DBOwner and all the properties, which suggest the same user as a db owner and
thus not providing sufficient info.
However using TRC - TRACE file under sql profiler and also using ErrorLog (not much great help however provides the
connection and user details (if errored)) I have came across the person's name who has done this.
The problem is we are using a AD based service account (which has a dbownership :w00t: :w00t: :angry: of these databases), which is common :angry: for cpl of databases across the whole farm, with some services running under same user.
So ultimately what we have came across is the service account user. 🙁 :exclamation:,, and that's end of the story !!!
Once again,, thanks mate,
Parth
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply