Restore database to particular point using Transaction log

Hi,

Thanks for The reply to the previous post.
Is it possible to restore database to particular point using Transaction log.
e.g. I am auditing the Accounts table and the user done some operations and then he feels their is some problem with system and he calls the DB Admin for changing the database to previous point. Is it possible with the Audit tool?

Thanks & Regards,
Nilesh Patil

Hi. The auditing is not based on transaction logs and has nothing to do with backing up or restoring the database. Users should use database backups to (for example, incremental transaction log backups) to allow point-in-time recovery. That is part of SQL Server built-in features.

By the way, transaction logs store very limited amount of activity data, virtually they store data changes only without the who and how information.

Hi,

Actually, Is it possible to revert back the changes in the Database. If possible then up-to which point?

Thanks & Regards,
Nilesh Patil