Our snapshot replication just stopped working about a week ago, and I have been trying to get it running ever since.
It seems to fail at the snapshot generation.
I get error messages containing such things as "unable to read column". There are also numerous timeouts on various steps with the notation that they will be restarted.
The process used to complete within about two hours. Now it runs for upwards of 8 hours and then errs out.
I note that all 32 Gb RAM gets used up in the process pretty much, though no out of memory messages are generated.
We are on sql server 2005 on windows server 2003 R2 SP2 Standard x64 Edition.
I don't have the error message right here to copy in, and I don't expect anyone to look at it that deeply.
I am just hoping for some tips and tricks or common experience sharing.