Help reqd on Checkpoints

Question

Help reqd on Checkpoints

debahuti_k

SSC Veteran

Points: 200
More actions
July 26, 2009 at 9:22 pm

#207368

I have say 10 million records loading into a package after loading 5 million records the package failed and using checkpoints how do u insert the rest of the remaining records starting from the next record from the point of failure?I want to know what is the total step by step procedure for doing it using checkpoints.
Thanks in advance
D.K

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

ps. One Orange Chip Points: 29422 More actions · Answer 1

When the package failed, it must have rolled back which means whatever was inserted would be undone. Atomicity of a trasaction means either all or none. So either all records will be imported or none (since it's a part of transaction). So no records in the target table. what was the recovery model of the database when u were performing import?

Checkpoint wont help here i believe.

quoting from BOL

Writes all dirty pages for the current database to disk. Dirty pages are data pages that have been entered into the buffer cache and modified, but not yet written to disk. Checkpoints save time during a later recovery by creating a point at which all dirty pages are guaranteed to have been written to disk.

Pradeep Singh

stevefromOZ SSC-Forever Points: 43646 More actions · Answer 2

@pradeep-2, different type of checkpoint (another case of MS re-using names :hehe:)

@dk - It's a little dated now but Jamie Thompson gives a nice overview of usage here.

Steve.

ps. One Orange Chip Points: 29422 More actions · Answer 3

stevefromOZ (7/26/2009)
@Pradeep, different type of checkpoint (another case of MS re-using names :hehe:)

They could have used atleast a synonym for the word checkpoint.:ermm:

That link was useful. thanks.:-)

I think this is was the OP is looking for..

Pradeep Singh

debahuti_k SSC Veteran Points: 200 More actions · Answer 4

Could you plz cit me an example where checkpoints are used and how to use them?

Thanks

D.K

stevefromOZ SSC-Forever Points: 43646 More actions · Answer 5

@dk -did you read the blog post? It contains a concise example (2 actually) of where one might use checkpoints and also includes implementation details.

Steve.