Applying snapshot on Subscriber – SQL SERVER 2005

5 pts.
Tags:
Snapshot
SQL Server 2005
SQL Server backup
hi,
about applying snaphot on the subscriber by copying the snapshot on the distributor and sending it to the subscriber.
i didnt get what/how this part. 
When the snapshot is created and the Distribution Agent begins processing it, stop the Distribution Agent. Once the SQL Server Agent job has stopped, navigate to the folder that the snapshot is in. By default this is C:Program FilesMicrosoft SQL ServerMSSQL10.MSSQLSERVERMSSQLrepldataunc, though the folder will vary depending on where you configured SQL Server to store the data.

Compress the files and folders in this folder with your favorite compression technique. Copy the compressed file to the Subscriber and decompress the data into a folder with the same path as the Distributor. Then edit the SQL Server Agent job and copy all the parameters in the SQL Agent job step.

On your Subscriber, open a command prompt and navigate to the COM folder and type "distrib.exe". Note that C:Program FilesMicrosoft SQL Server100COM is the default location for SQL Server 2008, and you can simply replace 100 with 90 or 80 for SQL Server 2005 and SQL Server 2000, respectively.

Paste the switches that you copied from the SQL Server Agent job step into the command window and press Enter. This will cause the Distribution Agent to temporarily run on the Subscriber, and it will process the snapshot from the copy that has been placed on the Subscriber.



my publisher and distributor are on the same server. merge replication with push.

thanks.



Software/Hardware used:
sql server 2005

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Denny Cherry
    Normally you won't need to do anything manually. Normally the SQL Server's replication agents can handle everything automatically without any special intervention on your part. Is there a reason that you are trying to load the snapshot from the subscriber, instead of pushing it from the distributor?
    66,130 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following