Problems with Maint Plan

02/02/2007, 15h25

I'm getting the following error with my Maint plan. I verified that all of
the databases and logs are being backed up. Any ideas?

EVENT # 18670
EVENT LOG Application
EVENT TYPE Warning
SOURCE SQLSERVERAGENT
CATEGORY Job Engine
EVENT ID 208
COMPUTERNAME INTAKE2003
TIME 2/1/2007 11:45:03 PM
MESSAGE SQL Server Scheduled Job 'Transaction Log Backup Job for DB
Maintenance Plan 'DB Maintenance Plan2'' (0xD91EBFF950DA494EBC7FDFFE49B3F828)
- Status: Failed - Invoked on: 2007-02-01 23:45:00 - Message: The job failed.
The Job was invoked by Schedule 20 (Schedule 1). The last step to run was
step 1 (Step 1).

02/02/2007, 18h03

What version and build of SQL Server are you running?

Chris

"Cwhitmore" <Cwhitmore@discussions.microsoft.com> wrote in message
news:3001D29D-FB80-47F3-B938-F3A867C1D212@microsoft.com...
> I'm getting the following error with my Maint plan. I verified that all of
> the databases and logs are being backed up. Any ideas?
>
> EVENT # 18670
> EVENT LOG Application
> EVENT TYPE Warning
> SOURCE SQLSERVERAGENT
> CATEGORY Job Engine
> EVENT ID 208
> COMPUTERNAME INTAKE2003
> TIME 2/1/2007 11:45:03 PM
> MESSAGE SQL Server Scheduled Job 'Transaction Log Backup Job for DB
> Maintenance Plan 'DB Maintenance Plan2''
> (0xD91EBFF950DA494EBC7FDFFE49B3F828)
> - Status: Failed - Invoked on: 2007-02-01 23:45:00 - Message: The job
> failed.
> The Job was invoked by Schedule 20 (Schedule 1). The last step to run was
> step 1 (Step 1).
>
>
>

02/02/2007, 18h12

Just a few questions: Is there anything on the SQL Server log? Is there
enough space to store the log? Are you trying to backup the master
database's log? Each of these could shed some light on the issue.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

02/02/2007, 18h19

Version 2000 SP4 (8.00.2039)

"Chris Wood" wrote:

> What version and build of SQL Server are you running?
>
> Chris
>
> "Cwhitmore" <Cwhitmore@discussions.microsoft.com> wrote in message
> news:3001D29D-FB80-47F3-B938-F3A867C1D212@microsoft.com...
> > I'm getting the following error with my Maint plan. I verified that all of
> > the databases and logs are being backed up. Any ideas?
> >
> > EVENT # 18670
> > EVENT LOG Application
> > EVENT TYPE Warning
> > SOURCE SQLSERVERAGENT
> > CATEGORY Job Engine
> > EVENT ID 208
> > COMPUTERNAME INTAKE2003
> > TIME 2/1/2007 11:45:03 PM
> > MESSAGE SQL Server Scheduled Job 'Transaction Log Backup Job for DB
> > Maintenance Plan 'DB Maintenance Plan2''
> > (0xD91EBFF950DA494EBC7FDFFE49B3F828)
> > - Status: Failed - Invoked on: 2007-02-01 23:45:00 - Message: The job
> > failed.
> > The Job was invoked by Schedule 20 (Schedule 1). The last step to run was
> > step 1 (Step 1).
> >
> >
> >
>
>
>

02/02/2007, 18h38

Paul,
I looked in the log and I do see an error about the same time. It says:
"Error: 15457, Severity: 0, State: 1"
Yes, we have plenty of space on that drive. Yes, I have the Maint plan
backing up all the databases.
Thanks,
Carlton.

"Paul Ibison" wrote:

> Just a few questions: Is there anything on the SQL Server log? Is there
> enough space to store the log? Are you trying to backup the master
> database's log? Each of these could shed some light on the issue.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>
>
>

02/02/2007, 21h43

The recovery mode is Full or Bulk_logged right?

Chris

"Cwhitmore" <Cwhitmore@discussions.microsoft.com> wrote in message
news:5272AE91-D4BA-4659-8F1C-6B89ADC7BC08@microsoft.com...
> Version 2000 SP4 (8.00.2039)
>
> "Chris Wood" wrote:
>
>> What version and build of SQL Server are you running?
>>
>> Chris
>>
>> "Cwhitmore" <Cwhitmore@discussions.microsoft.com> wrote in message
>> news:3001D29D-FB80-47F3-B938-F3A867C1D212@microsoft.com...
>> > I'm getting the following error with my Maint plan. I verified that all
>> > of
>> > the databases and logs are being backed up. Any ideas?
>> >
>> > EVENT # 18670
>> > EVENT LOG Application
>> > EVENT TYPE Warning
>> > SOURCE SQLSERVERAGENT
>> > CATEGORY Job Engine
>> > EVENT ID 208
>> > COMPUTERNAME INTAKE2003
>> > TIME 2/1/2007 11:45:03 PM
>> > MESSAGE SQL Server Scheduled Job 'Transaction Log Backup Job for DB
>> > Maintenance Plan 'DB Maintenance Plan2''
>> > (0xD91EBFF950DA494EBC7FDFFE49B3F828)
>> > - Status: Failed - Invoked on: 2007-02-01 23:45:00 - Message: The job
>> > failed.
>> > The Job was invoked by Schedule 20 (Schedule 1). The last step to run
>> > was
>> > step 1 (Step 1).
>> >
>> >
>> >
>>
>>
>>

02/02/2007, 23h24

If you're trying to backup the master database's log then this might be the
cause of the error.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

03/02/2007, 01h06

I was searching thru some posts and someone suggested not using the maint.
plan and creating jobs for each database. Should I just leave out the Master
from the Maint. plan or recreate a backup for each db?
thanks,
Carlton.

"Paul Ibison" wrote:

> If you're trying to backup the master database's log then this might be the
> cause of the error.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>
>
>
>
>

03/02/2007, 17h13

I must admit that I also personally prefer my own jobs as the logging tends
to be more extensive if/when things go wrong. However if you are using the
maint plans, just make sure that the master database is backed up but not
it's log attempted in the maint plan.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

02/02/2007, 15h25	#1
Cwhitmore Messages: n/a Hébergeur:	Problems with Maint Plan I'm getting the following error with my Maint plan. I verified that all of the databases and logs are being backed up. Any ideas? EVENT # 18670 EVENT LOG Application EVENT TYPE Warning SOURCE SQLSERVERAGENT CATEGORY Job Engine EVENT ID 208 COMPUTERNAME INTAKE2003 TIME 2/1/2007 11:45:03 PM MESSAGE SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan 'DB Maintenance Plan2'' (0xD91EBFF950DA494EBC7FDFFE49B3F828) - Status: Failed - Invoked on: 2007-02-01 23:45:00 - Message: The job failed. The Job was invoked by Schedule 20 (Schedule 1). The last step to run was step 1 (Step 1).

02/02/2007, 18h03	#2
Chris Wood Messages: n/a Hébergeur:	Re: Problems with Maint Plan What version and build of SQL Server are you running? Chris "Cwhitmore" <Cwhitmore@discussions.microsoft.com> wrote in message news:3001D29D-FB80-47F3-B938-F3A867C1D212@microsoft.com... > I'm getting the following error with my Maint plan. I verified that all of > the databases and logs are being backed up. Any ideas? > > EVENT # 18670 > EVENT LOG Application > EVENT TYPE Warning > SOURCE SQLSERVERAGENT > CATEGORY Job Engine > EVENT ID 208 > COMPUTERNAME INTAKE2003 > TIME 2/1/2007 11:45:03 PM > MESSAGE SQL Server Scheduled Job 'Transaction Log Backup Job for DB > Maintenance Plan 'DB Maintenance Plan2'' > (0xD91EBFF950DA494EBC7FDFFE49B3F828) > - Status: Failed - Invoked on: 2007-02-01 23:45:00 - Message: The job > failed. > The Job was invoked by Schedule 20 (Schedule 1). The last step to run was > step 1 (Step 1). > > >

02/02/2007, 18h12	#3
Paul Ibison Messages: n/a Hébergeur:	Re: Problems with Maint Plan Just a few questions: Is there anything on the SQL Server log? Is there enough space to store the log? Are you trying to backup the master database's log? Each of these could shed some light on the issue. Cheers, Paul Ibison SQL Server MVP, www.replicationanswers.com .

02/02/2007, 18h19	#4
Cwhitmore Messages: n/a Hébergeur:	Re: Problems with Maint Plan Version 2000 SP4 (8.00.2039) "Chris Wood" wrote: > What version and build of SQL Server are you running? > > Chris > > "Cwhitmore" <Cwhitmore@discussions.microsoft.com> wrote in message > news:3001D29D-FB80-47F3-B938-F3A867C1D212@microsoft.com... > > I'm getting the following error with my Maint plan. I verified that all of > > the databases and logs are being backed up. Any ideas? > > > > EVENT # 18670 > > EVENT LOG Application > > EVENT TYPE Warning > > SOURCE SQLSERVERAGENT > > CATEGORY Job Engine > > EVENT ID 208 > > COMPUTERNAME INTAKE2003 > > TIME 2/1/2007 11:45:03 PM > > MESSAGE SQL Server Scheduled Job 'Transaction Log Backup Job for DB > > Maintenance Plan 'DB Maintenance Plan2'' > > (0xD91EBFF950DA494EBC7FDFFE49B3F828) > > - Status: Failed - Invoked on: 2007-02-01 23:45:00 - Message: The job > > failed. > > The Job was invoked by Schedule 20 (Schedule 1). The last step to run was > > step 1 (Step 1). > > > > > > > > >

02/02/2007, 18h38	#5
Cwhitmore Messages: n/a Hébergeur:	Re: Problems with Maint Plan Paul, I looked in the log and I do see an error about the same time. It says: "Error: 15457, Severity: 0, State: 1" Yes, we have plenty of space on that drive. Yes, I have the Maint plan backing up all the databases. Thanks, Carlton. "Paul Ibison" wrote: > Just a few questions: Is there anything on the SQL Server log? Is there > enough space to store the log? Are you trying to backup the master > database's log? Each of these could shed some light on the issue. > Cheers, > Paul Ibison SQL Server MVP, www.replicationanswers.com . > > >

02/02/2007, 21h43	#6
Chris Wood Messages: n/a Hébergeur:	Re: Problems with Maint Plan The recovery mode is Full or Bulk_logged right? Chris "Cwhitmore" <Cwhitmore@discussions.microsoft.com> wrote in message news:5272AE91-D4BA-4659-8F1C-6B89ADC7BC08@microsoft.com... > Version 2000 SP4 (8.00.2039) > > "Chris Wood" wrote: > >> What version and build of SQL Server are you running? >> >> Chris >> >> "Cwhitmore" <Cwhitmore@discussions.microsoft.com> wrote in message >> news:3001D29D-FB80-47F3-B938-F3A867C1D212@microsoft.com... >> > I'm getting the following error with my Maint plan. I verified that all >> > of >> > the databases and logs are being backed up. Any ideas? >> > >> > EVENT # 18670 >> > EVENT LOG Application >> > EVENT TYPE Warning >> > SOURCE SQLSERVERAGENT >> > CATEGORY Job Engine >> > EVENT ID 208 >> > COMPUTERNAME INTAKE2003 >> > TIME 2/1/2007 11:45:03 PM >> > MESSAGE SQL Server Scheduled Job 'Transaction Log Backup Job for DB >> > Maintenance Plan 'DB Maintenance Plan2'' >> > (0xD91EBFF950DA494EBC7FDFFE49B3F828) >> > - Status: Failed - Invoked on: 2007-02-01 23:45:00 - Message: The job >> > failed. >> > The Job was invoked by Schedule 20 (Schedule 1). The last step to run >> > was >> > step 1 (Step 1). >> > >> > >> > >> >> >>

02/02/2007, 23h24	#7
Paul Ibison Messages: n/a Hébergeur:	Re: Problems with Maint Plan If you're trying to backup the master database's log then this might be the cause of the error. Cheers, Paul Ibison SQL Server MVP, www.replicationanswers.com .

03/02/2007, 01h06	#8
Cwhitmore Messages: n/a Hébergeur:	Re: Problems with Maint Plan I was searching thru some posts and someone suggested not using the maint. plan and creating jobs for each database. Should I just leave out the Master from the Maint. plan or recreate a backup for each db? thanks, Carlton. "Paul Ibison" wrote: > If you're trying to backup the master database's log then this might be the > cause of the error. > Cheers, > Paul Ibison SQL Server MVP, www.replicationanswers.com . > > > > >

03/02/2007, 17h13	#9
Paul Ibison Messages: n/a Hébergeur:	Re: Problems with Maint Plan I must admit that I also personally prefer my own jobs as the logging tends to be more extensive if/when things go wrong. However if you are using the maint plans, just make sure that the master database is backed up but not it's log attempted in the maint plan. Cheers, Paul Ibison SQL Server MVP, www.replicationanswers.com .

Outils de la discussion
Afficher une version imprimable Envoyer un lien vers cette page par email