O'Reilly logo

Microsoft SQL Server 2008 High Availability by Hemantgiri S. Goswami

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 6: Peer-to-Peer Replication

  • Question: While replicating LOB data, I get an error that reads The Distribution Agent is using the OLEDB streaming optimization for replicating binary large objects (LOB) greater than %1!d! byres. How can I resolve this?

    Answer: Increase the value for -OledbStreamThreshold using command line or creating a new agent profile.

  • Question: We would like to implement the P2P replication but we don't have the domain environment. What type of account should we use?

    Answer: You may use the identical windows username and password on the systems participating in replication, or you may use SQL Server account for replication.

  • Question: The following error appears in the error log "Index xxx is on table msXXX does not exist". ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required