.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

checkpoint ?

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :
what is a checkpoint ? how does it work ? please explain

View Complete Post

More Related Resource Links

Event Handlers don't execute after restart from checkpoint

Hi,   I have OnPreExecute and OnPostExecute Event Handlers on the Package level for custom logging.  They fire on pre/post exec for every task in the package as I wish.  They don't fire however when the package is restarted from a checkfile.  FailPackageOnFailure is set to false for the event handlers and every task within them.  I thought this was how to prevent the task from being written to checkfile and in turn prevent the task from failing to execute after restart. Is it true there are no workarounds for this behaviour? Thanks, Josh

Don't Understand Checkpoint / Buffer Cache Explanation in BOL

Checkpoints and the Active Portion of the Log     ? Checkpoints flush dirty data pages from the buffer cache of the current database to disk. This minimizes the active portion of the log that must be processed during a full recovery of a database. During a full recovery, the following types of actions are performed: The log records of modifications not flushed to disk before the system stopped are rolled forward. All modifications associated with incomplete transactions, such as transactions for which there is no COMMIT or ROLLBACK log record, are rolled back.   I don't understand this BOL page... From what I read in the first sentence above, the following must be true: I understand that SQL Server apparently doesn't save updated data directly to disk but stores it in RAM (the so-called Buffer Cache) until either this RAM buffer is full or until a checkpoint operation is executed.   If this is tue, Isn't this quite dangerous? What happens if the server is powered off? Are all updates that had been stored in the Buffer Cache / Log Cache lost? After a server restart, how can "The log records of modifications not flushed to disk before the system stopped" possibly be "rolled forward" if they had been stored in the Buffer Cache? After a server restart the Buffer Cache and the Log Cache must be empty! So there are no unsaved l

Transaction/checkpoint in container won't work when events is triggered


I have a package with a container and three "execute SQL tasks" (SELECT 1, SELECT 2/0 and SELECT 3) in it. The middle task has SELECT 2/0 SQL and so this have to go wrong. 


  • Transaction = required
  • FailpackageOnFail= true


  • transaction = supported
  • FailparentOnFailure = True

I've a checkpoint configured. The behaviour without a eventhandler is that the whole container is executed again from Task SELECT 1 after a error is corrected. With the event handler  ONError the container starts at task SELECT 2/0(without /0).

I think i know the answer already but i want to confirm my thoughts by you. When i add an OnError handler in the package for logging the error, the behaviour of the container differs when i DON'T add the eventhandler. I want to log the error AND  i want restartability of the container(start at task SELECT 1). After correcting the error the package is restarted as if there isn't a transaction on the container and i don't want that.

I can imagine that it isn't logical to have a transaction on the error handling because logging the error will also be rolled back. This may be a functional question but SSIS is behaving differently with an event oand no event handling and therefore i conclude that there are also technical rea

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend