Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Can i deliver merge replication snapshot on DVD or memory stick?

Отвечено Can i deliver merge replication snapshot on DVD or memory stick?

  • Monday, May 07, 2012 11:27 AM
     
     
    Sign In to Vote
    0

    Hi,

    I have set up merge replication pull subscription & with the help of "replmerg.exe" update the data for on demand synchronisation.

    But because of low network connectivity of client. Thery  nee to wait too long to get initial data.

    Now we want to deliver merge replication snapshot on memory sticks or DVD's so we can use them for subscription initialization.

    Guys please help me or at least provide me an idea about this.

     

All Replies

  • Monday, May 07, 2012 3:08 PM
    Moderator
     
     Answered
    Sign In to Vote
    1

    Absolutely. Copy the files to your device and then use the AltSnapshotFolder (for a non filtered publication) or DynamicSnapshotLocation for a dynamically filter publication as explained here:

    http://social.msdn.microsoft.com/Forums/zh/sqlreplication/thread/d27ace11-a891-4000-8698-25044685bf3f

    Note that with the AltSnapshotFolder you need to keep the replication snapshot folder location intact, whereas you don't for the DynamicSnapshotLocation parameter.

    looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941

    • Proposed As Answer by Peja TaoModerator Tuesday, May 08, 2012 8:09 AM
    • Marked As Answer by Mayur-DEW Friday, May 18, 2012 9:23 AM
    •  
     
  • Friday, May 11, 2012 7:50 AM
     
     
    Sign In to Vote
    0

    Hi Hilary,

    I will explain my setup in shot.

    I have publisher of 2k8 R2 enterprise edition. & subscriber having express edition.

    in express edition agent is absent then how can i generate a snapshot & how can i update it on serverside (i.e. publisher) because i have setup demand synchronisation pull subscription & to update data using "replmerg.exe" utility.

    so my question remain same.  if data is updated from subscriber side & there is a bad connectivity issue. then how is it possible to deliver replicatiion snapshot on stick?

    Please help me...

    following is the batch file syntax which I have used to update data manually.

    @echo off
    cls
    pause
    "C:\Program Files\Microsoft SQL Server\100\COM\replmerg.exe" replmerg.exe -PUBLISHER [SMD-0121] -PublisherDB [ToolRunEmptyDB] -Publication [SMD_0121Publication] -Subscriber [SMD-0260\SQLEXPRESS121] -SubscriberDB [ToolRunEmptyDB] -Distributor [SMD-0121]  -PublisherSecurityMode 1  -OutputVerboseLevel 2  -SubscriberSecurityMode 1  -SubscriptionType 1 -DistributorSecurityMode 1  
    exit

     
  • Friday, May 18, 2012 9:23 AM
     
     Answered
    Sign In to Vote
    0

    Hi Hilary,

    Thanks a ton, Finally i have got the solution the links which you have provided. same steps i have followed & successfully apply snapshot manually

    from subscribers end.

    • Marked As Answer by Mayur-DEW Friday, May 18, 2012 9:23 AM
    •  
     
  • Friday, September 14, 2012 10:56 AM
     
     
    Sign In to Vote
    0

    Hi

    I have setup a merge pull subscription, subscriber runs on sql express,windows 2003 32bit, So I use replmerg.exe to synchronize my subscriber database.

    I'm using dynamic snapshot, partitioned, parameterized filter. My snapshot file is around 3GB. Distributor and publisher are in same machine.

    When I try to run replmerg.exe from the subscriber, repmerg.exe memory grows upto 1.5 GB. Finally throws an error

    "The merge process could not allocate memory for an operation; your system may be running low on virtual memory. Restart the merge agent".

    I thought transferring 3GB file from publisher was the problem, so I copied the snapshot file to the subscriber and used AltSnapshotFolder property to to apply the snapshot on the subscriber. Still the same error.

    I guess replmerg.exe is trying to load the full snapshot file into memory. Its a 32Bit machine which is not scaling. 

    Are there any alternatives please suggest?

     
  • Friday, September 14, 2012 1:22 PM
    Moderator
     
     
    Sign In to Vote
    0
    This should not be happening. Can you restart SQL Server on the subscriber and perhaps even reboot the machine?

    looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941