Export (0) Print
Expand All
Expand Minimize

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).

  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.

    ms151862.note(en-US,SQL.90).gifNote:
    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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft