Social Icons

Pages

Wednesday, November 2, 2011

Process of creating Snapshot

     1. Open SQL Server Management Studio, connect to the publication server and expand the replication folder.

     2. Connect to the Publisher in Management Studio, and then expand the server node, expand the Replication folder, and then expand the Local Publications folder.

     3. Right-click the publication for which you want to create a snapshot, and then click Properties.

 
     4. On the publication properties, select the snapshot page.

  • To select file path thick check box “put file in the following folder”
  • To get compress snapshot file thick check box “compress snapshot files in this folder”
  • Click ok to save the modification.
     5. Right-click the publication and then click View Snapshot Agent Status.


6. Click start button to create snapshot.

 

 

No comments:

Post a Comment