Solved

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

Posted on 2001-06-11
4
1,799 Views
Last Modified: 2012-05-04
How i can read transaction log file (*.ldf) or rollback 1000 transactions? Is it's possible?
0
Comment
Question by:Harry_De_Sad
  • 2
4 Comments
 
LVL 2

Expert Comment

by:sefa
Comment Utility
There is a program for this..
visit this site...you may download a trial version.
www.lumigent.com
0
 
LVL 7

Expert Comment

by:lozzamoore
Comment Utility
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.
0
 
LVL 7

Expert Comment

by:lozzamoore
Comment Utility
Sorry, format is:
dbcc log ('dbname')
0
 
LVL 8

Accepted Solution

by:
chigrik earned 100 total points
Comment Utility
Read about "Viewing Transaction Log"
http://www.swynk.com/friends/achigrik/ViewLog.asp

Hope this helps
0

Featured Post

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Truncate vs Delete 63 87
ssms - object execution statistics 12 37
MS SQL 2014 get SPIDs of users 6 24
Link SQL table to Webpage 9 32
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now