Email Subscription random failure

Hi folks,
I installed SP1 onto our development box in hope this would fix an issue with Email subscriptions failing on occasion to send. The problem is that random subscriptions are not firing after the report content is update and notification is not sent to the subscribers.
After installing SP1 on our dev boxes it appears to happen less often but still occasionally loosing one of the 9 email subscriptions i'm sending to myself. When i check the report the content of the snapshot was refreshed but the last run date for the subscription is for the previous day.
Any ideas?Do you see anything in the log files indicating a failure?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Allan Unterschutz" <AllanUnterschutz@.discussions.microsoft.com> wrote in
message news:3F1EAEF9-4902-4C10-B3A7-370E00E92750@.microsoft.com...
> Hi folks,
> I installed SP1 onto our development box in hope this would fix an issue
with Email subscriptions failing on occasion to send. The problem is that
random subscriptions are not firing after the report content is update and
notification is not sent to the subscribers.
> After installing SP1 on our dev boxes it appears to happen less often but
still occasionally loosing one of the 9 email subscriptions i'm sending to
myself. When i check the report the content of the snapshot was refreshed
but the last run date for the subscription is for the previous day.
> Any ideas?|||Just to make sure, you are not expecting these on History snapshots are you?
Only report execution snapshots will generate the correct event for a
subscription.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Allan Unterschutz" <AllanUnterschutz@.discussions.microsoft.com> wrote in
message news:C7D230A4-D3B0-47C4-922F-86EECC7EF7F2@.microsoft.com...
> I checked all the log files and there are no entries at all for those
items. It seems to be only happening when you setup subscriptions to send
when content is refreshed.
> "Daniel Reib [MSFT]" wrote:
> > Do you see anything in the log files indicating a failure?
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "Allan Unterschutz" <AllanUnterschutz@.discussions.microsoft.com> wrote
in
> > message news:3F1EAEF9-4902-4C10-B3A7-370E00E92750@.microsoft.com...
> > > Hi folks,
> > >
> > > I installed SP1 onto our development box in hope this would fix an
issue
> > with Email subscriptions failing on occasion to send. The problem is
that
> > random subscriptions are not firing after the report content is update
and
> > notification is not sent to the subscribers.
> > >
> > > After installing SP1 on our dev boxes it appears to happen less often
but
> > still occasionally loosing one of the 9 email subscriptions i'm sending
to
> > myself. When i check the report the content of the snapshot was
refreshed
> > but the last run date for the subscription is for the previous day.
> > >
> > > Any ideas?
> >
> >
> >|||These email subscriptions are on the report execution snapshots. For now i'm going to be working around the issue and just setting up a seperate schedule for the emailing to (hopefully) occure after all reports are rendered.
"Daniel Reib [MSFT]" wrote:
> Just to make sure, you are not expecting these on History snapshots are you?
> Only report execution snapshots will generate the correct event for a
> subscription.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Allan Unterschutz" <AllanUnterschutz@.discussions.microsoft.com> wrote in
> message news:C7D230A4-D3B0-47C4-922F-86EECC7EF7F2@.microsoft.com...
> > I checked all the log files and there are no entries at all for those
> items. It seems to be only happening when you setup subscriptions to send
> when content is refreshed.
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> > > Do you see anything in the log files indicating a failure?
> > >
> > > --
> > > -Daniel
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > >
> > >
> > > "Allan Unterschutz" <AllanUnterschutz@.discussions.microsoft.com> wrote
> in
> > > message news:3F1EAEF9-4902-4C10-B3A7-370E00E92750@.microsoft.com...
> > > > Hi folks,
> > > >
> > > > I installed SP1 onto our development box in hope this would fix an
> issue
> > > with Email subscriptions failing on occasion to send. The problem is
> that
> > > random subscriptions are not firing after the report content is update
> and
> > > notification is not sent to the subscribers.
> > > >
> > > > After installing SP1 on our dev boxes it appears to happen less often
> but
> > > still occasionally loosing one of the 9 email subscriptions i'm sending
> to
> > > myself. When i check the report the content of the snapshot was
> refreshed
> > > but the last run date for the subscription is for the previous day.
> > > >
> > > > Any ideas?
> > >
> > >
> > >
>
>

Elusive Backup Process

Howdy Folks,

I have recently taken over looking after this machine & the previous guardian is unavailable. I've got to a point where I'm starting to think about looking into MSDB, but am not overly keen to start reviewing this db for obvious reasons... Can anyone please offer advise ?

Thank In Advance
Suze.

Environment: Microsoft SQL Server 2000 - 8.00.760 (sp3) on Win2000
H/W Dell PowerEdge 2550

Issue: Discovered in the sql log that there is a second set of bkps occurring around 7:30am - the bkps we have setup, run at 2am & are also being logged to sql log as completing normally.

The 7:30am bkps appear to be backing up to a remote location using pipes... or at a guess an agent ?? (I don't know know what that looks like cos we don't use agents). We backup db's to disk and then let arcserve pick up those backup files later.

I assume that this has been occurring for some time, sql logs back to July 7 advise so... Unable to locate scheduled job / maintenance plan that runs at this time...

Last night I set up a trace to catch it but that hasn't helped me either, apart from telling me that its an internal process to the server, and that the process actually started at 6:50am.

SQL LOGS Entries between midnight & 8am in attached file:

Trace contents in attached zip file:Someone had the sql agent installed on this server previously. It appears that the NT backup person still had it selected in the backup as well as the backups to disk. We have now removed this & shall wait and see tonight but I guess I now know what a remote agent arcserve backup looks like.

Cheers