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.
REFERENCES
For more information about concurrent snapshots, see the "How Transactional Replication Works" topic in Microsoft SQL Server 2000 Books Online.