Link to home
Start Free TrialLog in
Avatar of DataField
DataField

asked on

snapshot agent shut down (SQL Server 2000)

The database server is SQL server 2000.

The snapshot agent is on server1, which is set as publisher.  pull subscription is set on the server2.

After the replication is done, snapshot agent shut down and trigger the error (14150). Do you know what cause the agent to shut down?

Avatar of Kevin Hill
Kevin Hill
Flag of United States of America image

Please post the error message....I used to know that one off the top of my head, but not anymore

What sort of replication?  All three types use the snapshot agent
Avatar of DataField
DataField

ASKER

It is Merge replication.

There is one Snapshot Agent and one Merge Agent. But only Snapshot agent shut down after the replication. The merge agent is running.
I check the sql server log, and find the message as following at the time when snapshot agent shut down.

****************************************************************************
2005-04-02 00:45:02.45 backup    Log backed up: Database: ManageByNet, creation date(time): 2005/02/23(19:20:45), first LSN: 109378:1449:1, last LSN: 109378:1614:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'\\ces-svr2\Bk_ZID3172_SQL\CES-DB1\ManageByNet\ManageByNet_tlog_200504020045.TRN'}).


2005-04-02 00:57:46.04 spid51    Error: 14150, Severity: 10, State: 1

2005-04-02 00:57:46.04 spid51    Replication-Replication Snapshot Subsystem:
agent CES-DB1-ManageByNet-ManageByNet-2 succeeded. A snapshot of 11 article(s) was generated..


2005-04-02 01:00:02.22 backup    Log backed up: Database: Email, creation date(time): 2005/02/25(10:46:58), first LSN: 26:449:1, last LSN: 26:449:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'\\ces-svr2\Bk_ZID3172_SQL\CES-DB1\Email\Email_tlog_200504020100.TRN'}).
2005-04-02 01:00:03.16 backup    Log backed up: Database: ManageByNet, creation date(time): 2005/02/23(19:20:45), first LSN: 109378:1614:1, last LSN: 109378:2909:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'\\ces-svr2\Bk_ZID3172_SQL\CES-DB1\ManageByNet\ManageByNet_tlog_200504020100.TRN'}).

The snapshot agent will only run when a new snapshot needs to be generated.   Go into the replication monitor and look for the red X on the snapshot agent...that is the best place to get error details.
I went into the replication monitor, but there is no the red X on the snapshot agent there.

There is only one record there, see the following:
**********************************************************************
#Action  Last Action Message of Session                  Start Time                          Time of Last Action  Duration ...............
 1          A Snapshot of 11 articles was generated     '20050402 00:57.02.800'      '......'                      '00:00:44'
**********************************************************************


I guess there is no error for snapshot agent, just for some reason the snapshot agent shut down. what is the reason?
The snapshot agent shuts down when it is finshed.  Look at the schedule it runs on.  It will wake up periodically, look to see if any subscribers need new snapshot, and go back to sleep if not.  I think. :-)

No red X means you have no errors
thanks a lot for your information, let me see if it could wake up. It is schedule to run at weekend weekly.
ASKER CERTIFIED SOLUTION
Avatar of Kevin Hill
Kevin Hill
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial