Monday, March 12, 2012

Mysterious Error Message

I keep getting Timeout Expired with {call sp_MSget_repl_commands(8, ?, 0,
7500000)} in the error detail when attempting to replicate a 9.2gb database
over a wan link. The replication is transactional and other smaller test
databases replicate just fine. Any clue as to what this means?
Chris,
you could
(a) set the LoginTimeout to 0 and QueryTimeout to 0 which will mean that the
agent will not timeout
or
(b) compress the snapshot files (WINRAR or latest winzip), transfer the
file, uncompress it, then use the alternative snapshot location.
or
(c) transfer a backup and then do a noinit initialization.
Rgds,
Paul Ibison
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

No comments:

Post a Comment