?
Solved

snapshot agent shut down (SQL Server 2000)

Posted on 2005-04-04
8
Medium Priority
?
829 Views
Last Modified: 2008-01-09
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?

0
Comment
Question by:DataField
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
8 Comments
 
LVL 21

Expert Comment

by:Kevin3NF
ID: 13700236
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
0
 

Author Comment

by:DataField
ID: 13700465
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.
0
 

Author Comment

by:DataField
ID: 13700530
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'}).

0
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

 
LVL 21

Expert Comment

by:Kevin3NF
ID: 13700656
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.
0
 

Author Comment

by:DataField
ID: 13700751
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?
0
 
LVL 21

Expert Comment

by:Kevin3NF
ID: 13701075
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
0
 

Author Comment

by:DataField
ID: 13702196
thanks a lot for your information, let me see if it could wake up. It is schedule to run at weekend weekly.
0
 
LVL 21

Accepted Solution

by:
Kevin3NF earned 1500 total points
ID: 13702759
You don't need to wake it up if your subscribers have synched within the defined timeframes.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question