SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Restore database to particular point using Transaction log

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
Restore database to particular point using Transaction log
Author Message
Nilesh



Joined: 25 Aug 2011
Posts: 5
Country: India

Post Restore database to particular point using Transaction log Reply with quote
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
Thu Aug 25, 2011 8:33 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6499

Post Reply with quote
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.
Thu Aug 25, 2011 9:12 am View user's profile Send private message
Nilesh



Joined: 25 Aug 2011
Posts: 5
Country: India

Post Reply with quote
Hi,

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

Thanks & Regards,
Nilesh Patil
Thu Aug 25, 2011 10:55 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.