Post reply

DTS rollback

  • March 29, 2005 at 9:57 am

    #87173

    Hi all,

    Here's another hypothetical question, lets say I had a big DTS inserting ton of data, and I killed it in the middle. The DTS would roll back without any data modifications if it was just one big sql batch, right?

    Now, lets say I have same dts, but commiting data in 10000 row batches. When I kill it, it already commited some data, but not all. So now I have to go dig what data was commited, and which data remained the same, right?

    Or retore database?

    Thanks fo de help

     

  • March 30, 2005 at 12:46 pm

    #549633

    You are right.

    Use staging tables to load data from DTS, making sure the data conforms to what is needed, then do the Insert/Updates against the live tables as one transaction.

    Or just use DTS, and commit all the records at the same time.  This causes a table lock, though.

    cl

    Signature is NULL

  • March 30, 2005 at 7:12 pm

    #549704

    Thanx, makes sense with the staging tables. I actually smack the developers down for using large one-transactional dts to load data, 'cause it fills up the log. So staging tables may be it!

Viewing 3 posts - 1 through 2 (of 2 total)

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