Hello, I have a SERIOUS problem where I am restoring my SQL server (6.5) dump to my standby server everyday.......however, it often fails with the following msg:
'Unexpected end-of-dump while loading database, attempting to continue. Please verify database integrity. (Message 3103)'
It does also succeed, but too often fails and my standby server depends on it. The DB that gets restored is placed in single-user mode, so no other process or connection is allowed.
The backup to PROD runs at 12AM, for about 3 hours and succeeds always; the restore runs at 4:00...i've tried later times as well.
Can anyone tell me how to get near 100% success rate? What is the problem and how can I fix it? Thank you for the help.