No announcements
Found 1390695 threads
-
0 VotesSnapshot Agent Times Out At SP_MSACTIVATE_AUTO_SUB
), and now am trying to set the DB for Replication up again. For the past 10 hours the Snapshot Agent re-tried several times, and it has always gotten ...Answered | 5 Replies | 836 Views | Created by BogdanU - Friday, August 9, 2019 9:22 AM | Last reply by BogdanU - Tuesday, August 20, 2019 3:07 PM
-
0 Votes
timing out on downloading snapshot ?
Hi This is to do with HTTPS merge replication. We were getting an error when downloading the initial snapshot. The snapshot was about 25 meg, over an average link. ...Answered | 1 Replies | 7446 Views | Created by Bruce Baker - Sunday, February 26, 2006 5:29 AM | Last reply by Greg Y - Sunday, February 26, 2006 8:36 AM -
1 Votes
Snapshot Agent
history) is 1minute. The Snapshot job duration is only the time it takes to make the snapshot files. The distributer agent is responsible ...Discussion | 4 Replies | 3071 Views | Created by Asi Pesa - Monday, April 23, 2012 4:40 AM | Last reply by Hilary Cotter - Tuesday, April 24, 2012 12:19 PM -
0 Votes
Snapshot agent
It could be things like blocking or the snapshot agent running out of space on disk. What error message was raised? looking for a book on SQL ...Answered | 5 Replies | 1213 Views | Created by mito access - Thursday, July 30, 2015 10:13 AM | Last reply by Hilary Cotter - Friday, August 7, 2015 2:42 AM -
0 Votes
snapshot agents
Anyone have any idea why a snapshot agent runs longer when you use the command line? snapshot.exe -Publisher [SQLSERVER] -PublisherDB [DB001] -Distributor ... -
0 Votes
Checking out a snapshot by time
. If you applied label at the FILE level, then yes, you will only be able to get them one at a time. You'll need to do some more research from the Command ...Answered | 9 Replies | 5263 Views | Created by K.Kong - Friday, August 7, 2009 3:22 AM | Last reply by jclausius - SG - Tuesday, May 4, 2010 1:25 PM -
0 Votes
Snapshot Agent,
Hi Mark. The Snapshot agent isn't a 'continuous' agent, it basically runs to create a snapshot of the articles at a point in time for ...Answered | 4 Replies | 15775 Views | Created by Mark Cooray - Sunday, September 24, 2006 4:59 AM | Last reply by RubSay - Sunday, May 17, 2009 12:26 PM -
0 Votes
Snapshot agent.
to all Subscribers or until the Snapshot Agent runs and creates a new snapshot, whichever is longer. If the elapsed time between Snapshot Agent ...Answered | 9 Replies | 5940 Views | Created by vshan1 - Tuesday, January 8, 2008 7:37 AM | Last reply by vshan1 - Tuesday, January 8, 2008 8:23 PM -
0 Votes
Running Snapshot Agent is Recreating Snapshots
Any ideas -- one the articles has 100M records so I am not enthusiastic able waiting for it's snapshot everytime I run the snapshot agent.Answered | 5 Replies | 5830 Views | Created by JDWilson - Tuesday, October 11, 2011 8:14 PM | Last reply by JDWilson - Wednesday, October 12, 2011 1:31 PM -
0 Votes
Snapshot Agent missing files.
that is preventing the snapshot agent from continuing and then it times out and dies. But that is a total guess as I have not been able to observe the ...Answered | 3 Replies | 7616 Views | Created by Amy2006 - Tuesday, January 16, 2007 2:53 PM | Last reply by Raymond Mak - Wednesday, January 17, 2007 5:33 PM -
0 Votes
Snapshot agent cannot be started
the snapshot agent. It doesn´t go any further than saying "Snapshot agent is starting", and then nothing more happens. I can´t see whats wrong in the ... -
0 Votes
Snapshot Agent Problem
I'm getting this message when I try to run Merge Agents: "The Publisher has been restored from a backup whose schema change version is different from the Subscriber. ...Unanswered | 5 Replies | 5238 Views | Created by spike57 - Thursday, January 31, 2008 5:19 PM | Last reply by spike57 - Thursday, January 31, 2008 9:04 PM -
0 Votes
SnapShot Agent Status - Agent Shutdown
a snapshot.. when i see the snapshot Agent Status it's shows me like this. Executed as user: DomainName\SnapshotAgentAccount. ...Answered | 1 Replies | 7128 Views | Created by Shahzadi - Thursday, February 28, 2008 4:24 PM | Last reply by Emanuel Peixoto - Thursday, February 28, 2008 4:34 PM -
0 Votes
snapshot agent missing
Does the snapshot agent exist? I suspect it does not and you will need to add it like this sp_addpublication_snapshot ...Unanswered | 2 Replies | 2607 Views | Created by kidstuff - Tuesday, February 23, 2016 7:18 PM | Last reply by Hilary Cotter - Thursday, March 10, 2016 3:12 AM -
0 Votes
snapshot agent doesn't start
Enable verbose agent logging and see where it is getting stuck. Add the parameters -OutputVerboseLevel 2 -Output C:\TEMP\snapshotagent.log to the Snapshot ...Answered | 2 Replies | 7819 Views | Created by Hichem Chekebkeb - Tuesday, February 21, 2012 8:00 AM | Last reply by Brandon Williams - Tuesday, February 21, 2012 3:54 PM -
0 Votes
Snapshot Agents Mass Failure
new subscriptions quite frequently? if you are not then there is no reason to run the snapshot agent so often, you should run it on demand when you add the subscriber it at all ...Answered | 2 Replies | 5810 Views | Created by jmacpherson - Wednesday, December 19, 2007 9:09 AM | Last reply by jmacpherson - Saturday, December 29, 2007 5:19 PM -
0 Votes
Transactional Replication- Snapshot agent
IF your snapshot agent job is currently running on a scheduled basis, you can modify the job's schedule, find the job in sql server agent job list and edit the schedule.Answered | 2 Replies | 7384 Views | Created by samsan - Thursday, September 7, 2006 2:03 PM | Last reply by Greg Y - Monday, September 11, 2006 3:25 PM -
0 Votes
Replication snapshot agent failure
the snapshot agent job from SQL Server Agent – Jobs, and see if it is still running. Or we can find out whether it is running or not by using the ...Answered | 4 Replies | 8398 Views | Created by Vipin Das - Tuesday, July 20, 2010 12:01 PM | Last reply by Vipin Das - Tuesday, August 16, 2011 7:17 AM -
0 Votes
Snapshot Agent Recommendation
Running the Snapshot Agent once per day should be fine and is the default schedule for Transactional Replication. I tend to schedule this during a time of ...Answered | 1 Replies | 3069 Views | Created by exitista - Friday, March 2, 2012 8:16 PM | Last reply by Brandon Williams - Friday, March 2, 2012 8:44 PM -
0 Votes
snapshot agent question
after the publication is created in the New Publication Wizard. Subsequently, the agent runs according to a schedule you specify. Whether the agent creates new ...Answered | 4 Replies | 2195 Views | Created by aliyesami - Monday, November 12, 2012 3:10 PM | Last reply by Hilary Cotter - Sunday, November 25, 2012 6:58 PM - Items 1 to 20 of 1390695 Next ›
No announcements
