Need help with database usage history and backtrack

[atifahmedsiddiqui]

Hi all,

I had a problem with my database, some one among my team did overwrite/restore the database by mistake, and now I want my old data back.
I do have backup that I can restore, but still I am in search of the trace log to backlog so that I can find out who did that overwriting.

please if any body have any idea about how to get the usage history or any usage log in sql server, do post here.

Thanks in advance.

Regards,
Atif

[radcaesar]

Whats the version of SQL SERVER ?
Have you enable audit logs ?

Else,
Right click --> MyComputer
select Manage
In the Left pan goto Logs --> Application log
There you find your SQL Server Application log

But Audit log was preferable

Visit this,

http://www.microsoft.c om/technet/security/prodtech/sqlserver/sql2kaud.mspx