Re: SQL Crashing Sporaticitaclly

- Are you seeing any Publisher Error messages under Replication
Monitor->Publishers->Server->Publication?

-----No, there are no errors

- Have you tried enabling one Subscriber at a time (Activate Sql Server

Agent at remote, then Start synchronizing)?

-----Yes, I enabled on at a time, over a 2 hour period. Currently the
servrer
is up, but I have not been able to figure out what happened. This is
the second
time this has happened & the only way I have been able to get it fixed
is to
stop all the SQL Servrer Agents at all the remote loations, then
restart them.

- Did something unexpected happen such as a large number of updates at
one time? This happened to me once, when our new DBA accidentally
updated 150,000 records (which locked everything up).

-----I wear the DBA hap, amond others, I do not know of any massive
updates that
have been done.

Thanks,
Larry...

.

Relevant Pages

  • Re: SQL Crashing Sporaticitaclly
    ... - Have you tried enabling one Subscriber at a time (Activate Sql Server ... Agent at remote, then Start synchronizing)? ...
    (microsoft.public.sqlserver.replication)
  • Re: TS vs VPN
    ... Using TS, w/o VPN ... The remote client connects to your local TS via Remote Desktop. ... "Foo" accesses the SQL server, which is nearby in a protected part of the network. ...
    (microsoft.public.windows.terminal_services)
  • Re: Network traffic with transactional replication with immediate updates (SQL 2005)
    ... publisher/distributor running on the main office and a subscriber at the ... This is a new SQL Server 2005 behaviour, ... the agent should execute them (maybe the agent just ... I cannot find a way to explain why Distributor Agents are to ...
    (microsoft.public.sqlserver.replication)
  • Re: Network traffic with transactional replication with immediate updates (SQL 2005)
    ... publisher/distributor running on the main office and a subscriber at the ... the agent should execute them (maybe the agent just launches ... Looking for a SQL Server replication book? ... I cannot find a way to explain why Distributor Agents are to ...
    (microsoft.public.sqlserver.replication)
  • Re: Remote Database Connection with PocketPC/MSAccess Front End
    ... If you want to allow direct remote access for your Access data, I'd suggest writing a web service which your remote apps could use. ... The general problem with mobile access to remote data of any kind (including SQL Server which Windows Mobile devices can access directly remotely) is that sometimes the connection just isn't there. ... Generally the easiest backend data store to use for this local cache is going to be SQL Server Compact, which supports several sync strategies including the Access Sync Services that your question isn't about. ...
    (microsoft.public.pocketpc.developer)