June 5, 2008 at 4:22 am
How can i find out when a database was deleted?
I have checked error.log, event.log and system event viewer but cannot find anything that says when it was deleted.
The server was upgraded in situ from 2000 - 2005 while i was away - on the 7th May database showed in the startup db events and on the 10th it was no longer there...no trace of it... the 7th was the day it was upgraded but the logs says the upgrade was complete.
Are there any tables in master/msdb that would record when the database was deleted and by whom?
any help greatly appreciated...
Oraculum
June 5, 2008 at 7:04 am
Try To Execute the Below Code
DBCC LOG(MASTER,4)
Can you find any dbdestroy in description field.
Regards,
Raj
June 5, 2008 at 7:28 am
luckily a trace was being performed and i have caught the dbcc detach command and know when and who! Thanks 😉
Oraculum
June 5, 2008 at 7:47 am
Lucky Man 😉
What Happened To The De Attacher ? :w00t:
Regards,
raj
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply