Note: Forums will be making significant UX changes to address key usability improvements surrounding search, discoverability and navigation. To learn more about these changes please visit the announcement which can be found HERE.

SQL Server >

SQL Server Forums >

SQL Server Replication >

Will the replication automatically recovery to multi-stream mode automatically if it changed to single mode due to some action fail

Will the replication automatically recovery to multi-stream mode automatically if it changed to single mode due to some action fail

Wednesday, December 26, 2012 8:03 AM

0

hi:

My replication is transactional replication.I use 32 streams in distribute agent. It will change to single stream if enounter some fail. Does it recovery to multi-stream after succeed in resubmit with single stream.If not, how can I configure it to automatically recovery the multi-streams modle.thanks
- Reply
- Quote

All Replies

Wednesday, December 26, 2012 4:28 PM

Moderator

0
It will automatically unthrottle itself from a single thread to multi threads after the erorr is cleared. There was a bug in SQL 2005 IIRC which would prevent it from going back to multi-threaded.
looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
- Proposed As Answer by Allen Li - MSFTModerator Wednesday, January 02, 2013 1:59 AM
- Reply
- Quote

Frequently asked questions - Forums help