A
Adrian.wright
Guest
Hi All we started a Bullkload Proccess on a Table with 70 million Records which took about 7 days plus to complete, but when the Bulk upload completed there is a difference of about 500K records missing from Target\SQL server, I hoped when we enabled the Table Triggers this would autmatically catch up\replicate the missiing 500K which after 4 days its only provided the Table Trigger updates, so the questions I have are.... 1. why\how did this occur, is this beacuse we didn't enable the Database Triggers at the same time as the Bulkload ? and is this something we should do for furture tables ? 2. The missing 500K is probably the difference between the Bulkload starting and the 7 days it took to finish, so that would imply that the Record count is taken at the start of the bulkload ? so everythin after that should be an update ? and should the Table trigger not have transferred the 500K ? 3. the most important, how do we rectify this, would stating a Bulkload again for that table be a risk ? as it is 70 millions records in the table I would not want to have truncate the Target Table and start again from scratch especially just for 500K records Many Thanks in Advance ADe
Continue reading...
Continue reading...