Join | Login | Why Join?   
SQL Server, Oracle, DB2, Sybase, MySQL Help - SSWUG.ORG HACKER SAFE certified sites prevent over 99.9% of hacker crime.
Search SSWUG:   
 
Access to 467 free guest articles, discussions and more, just create your free SSWUG User ID:
Email address:  
This will be your login ID - we'll email you your password - you'll even receive the newsletter, opt-out at any time.
Email to Friend //  Discuss Article //  Rate Article //  Digg Article //  Add to Del.icio.us //  Add to Technorati

 

Rolling Back a Transaction in the Transaction Log File

Available for Members. This is an off-site link. Please review our Terms of Service (bottom of page) for additional information.  See Related Articles


 Article Abstract:

To prevent data corruption, SQL Server does not support the rollback of individual transactions. For example, suppose that two transactions, T1 and T2, use a cash balance field. T1 adds $500 U.S., and T2 makes a change by using that new value. If you roll back T1, T2 might be wrong. However, you can restore a log to a predefined mark or a point in time by using timestamps, as example one below shows, or transaction log marks, as example two shows. Both examples use SQL Server 2000 syntax.

 Read this article...
 Related Articles - For Members.
Managing rollback segments
A high value of Rollback per Transaction...Is it alarming ?
Understanding the SQL Server Transaction Log
Tuning the Oracle Server - Identifying Internal Contention
Production Rollout Checklists - A sample and how they can help
Who is Using Which Rollback?
Optimal size of rollback segments
RBS monitor to catch ORA-1555 errors



Key (Please note):
(R) - registration may be required for access at the target site
($) - target site may require paid membership for access to this or other content

No Comments/Feedback Posted Yet. Post Your Comments/Feedback

Email to Friend //  Discuss Article //  Rate Article //  Digg Article //  Add to Del.icio.us //  Add to Technorati

   



 

[ Register ] [ Webcasts ] [ Podcasts ] [ Newsletter Archive ] [ RSS/Feeds ]
[ About ] [ Advertise ] [ Contact ] [ Privacy ] [ Terms of Service ]
[ Link to SSWUG ] [ List Server Archives ] [ Recent Orig. Content ]
(c) 1997-2008, Bits on the Wire, Inc.  (0)

Some names and products covered by SSWUG are the registered trademarks of their respective owners.
DAA10354WWW004