March 22, 2012 at 10:29 am
I used DTS to import a table from one server (2005) to another (2008) yesterday. Today I've noticed that the source table has 24713 records but my imported table has only 24673. If I do the same thing today I get the full complement.
The package reported success and there's no apparent pattern to the missing records (first/last 40 etc.). I'm confident that neither source nor target has been modified since.
Is there any precedent for this? I'm being asked to explain where the data went and I'm at a total loss.
March 22, 2012 at 10:33 am
Only way to know for sure would be to restore the source database from yesterday and verify that nothing changed between yesterday and today. You will want to see the source database as close to the time you ran the extract yesterday.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply