Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

snapshot agent shut down (SQL Server 2000)

Posted on 2005-04-04
8
Medium Priority
?
839 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
  • 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

Lotus Notes has been used since a very long time as an e-mail client and is very popular because of it's unmatched security. In this article we are going to learn about  RRV Bucket corruption and understand various methods to Fix "RRV Bucket Corrupt…
In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
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…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
Suggested Courses

572 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