Link to home
Start Free TrialLog in
Avatar of Harry_De_Sad
Harry_De_Sad

asked on

How i can read transaction log file (*.ldf) or rollback 1000 transactions?

How i can read transaction log file (*.ldf) or rollback 1000 transactions? Is it's possible?
Avatar of sefa
sefa

There is a program for this..
visit this site...you may download a trial version.
www.lumigent.com
You can use:
DBCC LOG 'dbname' to view the transaction log.

As for rolling back transations, only to a saved point in a log, or a discrete log backup during a restore.
Sorry, format is:
dbcc log ('dbname')
ASKER CERTIFIED SOLUTION
Avatar of chigrik
chigrik

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial