Thanks so much!  Valuable information that I can take to our discussion table. 

KR

Thank you much for the info.

KR

Well, we have currently backup happening every night on the subscriber.   The publisher backups are scheduled differently and it is in Full Recovery Module with full and transaction log back...

I am not sure I understand your process correctly.  We would need the "old" snapshot data that has been transferred every quarter for historical report purposes.  We transfer data from our production...

I did not go that route.  Anyway I have since solved this problem-  The logfile path was set to a mapped drive vs a UNC, and changing fixed it.

Thanks for...

I am able to run the package through EM, althought I did find the problem with the log file - The path was a mapped drive vs a UNC path. ...

That is probably a better idea!  - creating an entry into the audit table.  I will certainly look into that option.  The only problem with the permissions thing is it...

John,

After much digging it does seem that the missing data was once replicated and was probably was deleted, but the two users who have access to update this database are...

We have a specific problem, one of two of our subscribers is not in sync with the published database.  The set up is pretty simple - Transactional replication - one...

Thank You!  This information gives me a good starting point

Thanks for the information.  It is helpful to understand how this process works.

I did think Simple recovery was not such a good option and did not set it up this...

I have.  However I am looking at another way to solve the problem of copying data into the temp file, so hopefully I will not need to resolve this particular...

Yes,  that is the spreadsheet name. The sql server account does have access to E:\WUTemp.

Thanks You all!  You given me a good starting point to work on!

KR

I am looking more in terms of building something myself to do the comparison - at this time just the first and last names. 

KR