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.
sql server 2005
September 12, 2009 6:21 PM
September 14, 2009 1:24 PM