How to: Specify Snapshot Format (SQL Server Management Studio)

Specify snapshot format on the Snapshot page of the Publication Properties - <Publication> dialog box. For more information about accessing this dialog box, see How to: View and Modify Publication and Article Properties (SQL Server Management Studio).

To specify snapshot format

  1. On the Snapshot page of the Publication Properties - <Publication> dialog box, select Native SQL Server - all Subscribers must be servers running SQL Server or Character - required if a Publisher or Subscriber is not running SQL Server.


    It is recommended to select the native format unless this publication must support subscriptions to a Microsoft SQL Server 2005 Compact Edition database or a non-SQL Server database.

  2. Click OK.

See Also


Changing Publication and Article Properties
Initializing a Subscription with a Snapshot

Other Resources

How to: Configure Snapshot Properties (Replication Transact-SQL Programming)

Help and Information

Getting SQL Server 2005 Assistance