Microsoft KB Archive/267263

= SQL Server 2000 concurrent snapshot is not supported for SQL Server 7.0 pull subscriptions =

Article ID: 267263

Article Last Modified on 12/17/2004

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition
 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q267263



SUMMARY
When you create a transactional publication within Microsoft SQL Server 2000, concurrent snapshots can be enabled if subscription types are selected to be Microsoft SQL Server 7.0 or Microsoft SQL Server 2000.

In fact, a SQL Server 2000 concurrent snapshot is only supported for SQL Server 7.0 push subscriptions, but not pull subscriptions. A SQL Server 7.0 pull Distribution agent to a SQL Server 2000 publication fails with the following error message when you apply concurrent snapshot files:

Invalid distribution command type.

So, you need to disable concurrent snapshots for any SQL Server 7.0 pull subscription that needs data initialization. You can implement this with either the Enterprise Manager or the sp_changepublication stored procedure.

NOTE: Changing this property requires re-initialization of all subscriptions.

 Use the following steps to re-initialize the subscriptions:

 In the Enterprise Manager, right-click the publication, and then click Properties. Click the Snapshot tab, and then clear the check box under Concurrent access during snapshot generation.

-or-

 Use the sp_changepublication stored procedure to change the @sync_method to native or character.

Concurrent snapshot is supported for all SQL Server 2000 subscriptions.