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?
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?
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.
There is one Snapshot Agent and one Merge Agent. But only Snapshot agent shut down after the replication. The merge agent is running.
ASKER
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_SQ L\CES-DB1\ ManageByNe t\ManageBy Net_tlog_2 0050402004 5.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-Manage ByNet-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_SQ L\CES-DB1\ Email\Emai l_tlog_200 504020100. 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_SQ L\CES-DB1\ ManageByNe t\ManageBy Net_tlog_2 0050402010 0.TRN'}).
**************************
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_SQ
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-Manage
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_SQ
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_SQ
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.
ASKER
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?
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
No red X means you have no errors
ASKER
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
What sort of replication? All three types use the snapshot agent