Applying snapshot on Subscriber – SQL SERVER 2005
hi,
Software/Hardware used:
sql server 2005
i've read on this articlehttp://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1362610_mem1,00.html
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.
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
ASKED:
September 12, 2009 6:21 PM
UPDATED:
September 14, 2009 1:24 PM
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
All Answer Wiki Contributors:
Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.
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?