By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,480 Members | 1,144 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,480 IT Pros & Developers. It's quick & easy.

Need help with database usage history and backtrack

P: 1
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
Feb 16 '08 #1
Share this Question
Share on Google+
1 Reply


radcaesar
Expert 100+
P: 759
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.com/technet/security/prodtech/sqlserver/sql2kaud.mspx
Feb 22 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.