Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

How do I export / view changes between 3:00am and 8:30am on my database? I have people entering data to the server and during that time, we had an issue where people data were not properly entered into the system.

Thanks!

share|improve this question

3 Answers 3

There is a good discussion of the issue in this forum post. The bottom line is transaction logs are not meant for reviewing what happened but are part of the internal working of SQL and disaster recovery. Most importantly you cannot find out who did what from a transaction log. You need auditing enabled for that.

There is a link to this 3rd party tool that may help.

share|improve this answer

Not much help in 2011 - but if you are using SQL Server 2000 only, there's a free (and hence very limited support) version by Redgate:

http://www.red-gate.com/products/dba/sql-log-rescue/

share|improve this answer

Ajit Ananthram's blog post covers the options (Change Tracking, Change Data Capture, Service Broker with External Activator) in detail.

share|improve this answer
    
Providing a link with details is good, but including a basic overview on what to do to accomplish the goal is more helpful to OP. –  fuero Feb 6 '13 at 9:35

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.