Maintenance plan backups fail

Hi, I have a scheduled maintenance plan that backs up my database (SQL 2000). The db is 108 Meg. Usually the backup files are around 89 Meg and the transaction log backups are around 4.5 Megs.

The problem is that every once a while the backup fails with the following error:

[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3202: [Microsoft][ODBC SQL Server Driver][SQL Server]Write on 'C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\CRM_db_200312230100.BAK' failed, status = 112. See the SQL Server error log for more details.
[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is terminating abnormally.

What usually happens is that the last backup that has failed has a size of 9 or 8 Gigs!

My guess is that a backup file gets corrupt (the size increases to 8 Gigs) and the server runs out of space and wont be able to do more backups. However I cant figure out why the backup file size increases to and gets corrupt.

Can anyone help me?What does the error log say...

did you a dbcc checkdb?|||Thanks for your reply, the error log says:

1.Source:Backup
BACKUP failed to complete the command BACKUP DATABASE [MYDB] TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\MYDB_db_200312230100.BAK' WITH INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT

2.Source:spid54
BackupMedium::ReportIoError: write failure on backup device 'C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\MYDB_db_200312230100.BAK'. Operating system error 112(There is not enough space on the disk.).

3.Source:spid54
Internal I/O request 0x12844D98: Op: Write, pBuffer: 0x12C40000, Size: 983040, Position: 14752256, UMS: Internal: 0x103, InternalHigh: 0x0, Offset: 0xE11A00, OffsetHigh: 0x0, m_buf: 0x12C40000, m_len: 983040, m_actualBytes: 0, m_errcode: 112, BackupFile: C:\Program Files\Microsoft SQL

It looks like somthing happended to the last backup and the size increased to 8 Gigs and the disk ran out of space, but I can't figure why this happenes every once in a while.

Thanks



Originally posted by Brett Kaiser
What does the error log say...

did you a dbcc checkdb?|||You can't just assume that the backup gets corrupted without trying to restore it. Have you tried to do that?|||I havn't but there must be somthing wrong with it, since its 8 gig instead of 80 Megs, plus when I deleted it and made a backup manualy the size of the new backup was the regular 80 megs

Originally posted by rdjabarov
You can't just assume that the backup gets corrupted without trying to restore it. Have you tried to do that?

Maintenance Plan "fails"..

Thanks in advance for any insight.
On occasion, one of my schedule jobs will "fail", in that all tasks
complete, but it still reports failure. Strangely enough, nothing is written
to SQL Server log, but I do have the following entry in the Event Viewer:
"SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'Non-Great
Plains Daily Backup'' (0x01BF5D1C32E9FF418D67E99A77A4A014) - Status:
Failed - Invoked on: 2004-06-08 20:00:00 - Message: The job failed. The Job
was invoked by Schedule 35 (Schedule 1). The last step to run was step 1
(Step 1)."
Any ideas on how to troubleshoot this?
Thanks,
MorganAny messages in the report file? (Did you specify a report file, btw?)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Morgan" <abcd@.senditon.com> wrote in message news:eiY8NRjTEHA.1284@.TK2MSFTNGP10.phx.gbl...[
vbcol=seagreen]
> Thanks in advance for any insight.
> On occasion, one of my schedule jobs will "fail", in that all tasks
> complete, but it still reports failure. Strangely enough, nothing is writt
en
> to SQL Server log, but I do have the following entry in the Event Viewer:
> "SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'Non-Grea
t
> Plains Daily Backup'' (0x01BF5D1C32E9FF418D67E99A77A4A014) - Status:
> Failed - Invoked on: 2004-06-08 20:00:00 - Message: The job failed. The Jo
b
> was invoked by Schedule 35 (Schedule 1). The last step to run was step 1
> (Step 1)."
> Any ideas on how to troubleshoot this?
>
> Thanks,
> Morgan
>[/vbcol]|||Hi Tibor,
The only thing in the report file is that it was unable to delete one of the
database backups. Other than that, all of the steps completed. Would that
cause the job to think it failed?
Thanks,
Morgan
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ubeNMltTEHA.2544@.TK2MSFTNGP10.phx.gbl...
> Any messages in the report file? (Did you specify a report file, btw?)
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Morgan" <abcd@.senditon.com> wrote in message
news:eiY8NRjTEHA.1284@.TK2MSFTNGP10.phx.gbl...
written[vbcol=seagreen]
Viewer:[vbcol=seagreen]
'Non-Great[vbcol=seagreen]
Job[vbcol=seagreen]
>|||If I wrote the code, yes a failed deletion of a backup file would cause the
job to fail.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Morgan" <abcd@.senditon.com> wrote in message news:eVp7v$uTEHA.3988@.tk2msftngp13.phx.gbl...[
vbcol=seagreen]
> Hi Tibor,
> The only thing in the report file is that it was unable to delete one of t
he
> database backups. Other than that, all of the steps completed. Would that
> cause the job to think it failed?
> Thanks,
> Morgan
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n
> message news:ubeNMltTEHA.2544@.TK2MSFTNGP10.phx.gbl...
> news:eiY8NRjTEHA.1284@.TK2MSFTNGP10.phx.gbl...
> written
> Viewer:
> 'Non-Great
> Job
>[/vbcol]|||Ha! I hear ya. Would be nice if each piece of a maintenance plan could be a
seperate job, that way if deleting a previous days backup failed it wouldn't
look like the databases didn't get backed up since that would be a seperate
task with its own status.
Thanks,
Morgan
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:e3i9JIvTEHA.644@.tk2msftngp13.phx.gbl...
> If I wrote the code, yes a failed deletion of a backup file would cause
the job to fail.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Morgan" <abcd@.senditon.com> wrote in message
news:eVp7v$uTEHA.3988@.tk2msftngp13.phx.gbl...
the[vbcol=seagreen]
that[vbcol=seagreen]
in[vbcol=seagreen]
The[vbcol=seagreen]
step 1[vbcol=seagreen]
>|||A "hack" way is to create a script that does a "DIR" in the directory and de
lete old files. This can be done
using ActiveScript, TSQL of whatever is your preference...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Morgan" <abcd@.senditon.com> wrote in message news:OPwIwByTEHA.3480@.TK2MSFTNGP11.phx.gbl...[
vbcol=seagreen]
> Ha! I hear ya. Would be nice if each piece of a maintenance plan could be
a
> seperate job, that way if deleting a previous days backup failed it wouldn
't
> look like the databases didn't get backed up since that would be a seperat
e
> task with its own status.
> Thanks,
> Morgan
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n
> message news:e3i9JIvTEHA.644@.tk2msftngp13.phx.gbl...
> the job to fail.
> news:eVp7v$uTEHA.3988@.tk2msftngp13.phx.gbl...
> the
> that
> in
> The
> step 1
>[/vbcol]

Maintenance Plan "fails"..

Thanks in advance for any insight.
On occasion, one of my schedule jobs will "fail", in that all tasks
complete, but it still reports failure. Strangely enough, nothing is written
to SQL Server log, but I do have the following entry in the Event Viewer:
"SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'Non-Great
Plains Daily Backup'' (0x01BF5D1C32E9FF418D67E99A77A4A014) - Status:
Failed - Invoked on: 2004-06-08 20:00:00 - Message: The job failed. The Job
was invoked by Schedule 35 (Schedule 1). The last step to run was step 1
(Step 1)."
Any ideas on how to troubleshoot this?
Thanks,
Morgan
Any messages in the report file? (Did you specify a report file, btw?)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Morgan" <abcd@.senditon.com> wrote in message news:eiY8NRjTEHA.1284@.TK2MSFTNGP10.phx.gbl...
> Thanks in advance for any insight.
> On occasion, one of my schedule jobs will "fail", in that all tasks
> complete, but it still reports failure. Strangely enough, nothing is written
> to SQL Server log, but I do have the following entry in the Event Viewer:
> "SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'Non-Great
> Plains Daily Backup'' (0x01BF5D1C32E9FF418D67E99A77A4A014) - Status:
> Failed - Invoked on: 2004-06-08 20:00:00 - Message: The job failed. The Job
> was invoked by Schedule 35 (Schedule 1). The last step to run was step 1
> (Step 1)."
> Any ideas on how to troubleshoot this?
>
> Thanks,
> Morgan
>
|||Hi Tibor,
The only thing in the report file is that it was unable to delete one of the
database backups. Other than that, all of the steps completed. Would that
cause the job to think it failed?
Thanks,
Morgan
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ubeNMltTEHA.2544@.TK2MSFTNGP10.phx.gbl...
> Any messages in the report file? (Did you specify a report file, btw?)
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Morgan" <abcd@.senditon.com> wrote in message
news:eiY8NRjTEHA.1284@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
written[vbcol=seagreen]
Viewer:[vbcol=seagreen]
'Non-Great[vbcol=seagreen]
Job
>
|||If I wrote the code, yes a failed deletion of a backup file would cause the job to fail.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Morgan" <abcd@.senditon.com> wrote in message news:eVp7v$uTEHA.3988@.tk2msftngp13.phx.gbl...
> Hi Tibor,
> The only thing in the report file is that it was unable to delete one of the
> database backups. Other than that, all of the steps completed. Would that
> cause the job to think it failed?
> Thanks,
> Morgan
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:ubeNMltTEHA.2544@.TK2MSFTNGP10.phx.gbl...
> news:eiY8NRjTEHA.1284@.TK2MSFTNGP10.phx.gbl...
> written
> Viewer:
> 'Non-Great
> Job
>
|||Ha! I hear ya. Would be nice if each piece of a maintenance plan could be a
seperate job, that way if deleting a previous days backup failed it wouldn't
look like the databases didn't get backed up since that would be a seperate
task with its own status.
Thanks,
Morgan
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:e3i9JIvTEHA.644@.tk2msftngp13.phx.gbl...
> If I wrote the code, yes a failed deletion of a backup file would cause
the job to fail.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Morgan" <abcd@.senditon.com> wrote in message
news:eVp7v$uTEHA.3988@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
the[vbcol=seagreen]
that[vbcol=seagreen]
in[vbcol=seagreen]
The[vbcol=seagreen]
step 1
>
|||A "hack" way is to create a script that does a "DIR" in the directory and delete old files. This can be done
using ActiveScript, TSQL of whatever is your preference...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Morgan" <abcd@.senditon.com> wrote in message news:OPwIwByTEHA.3480@.TK2MSFTNGP11.phx.gbl...
> Ha! I hear ya. Would be nice if each piece of a maintenance plan could be a
> seperate job, that way if deleting a previous days backup failed it wouldn't
> look like the databases didn't get backed up since that would be a seperate
> task with its own status.
> Thanks,
> Morgan
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:e3i9JIvTEHA.644@.tk2msftngp13.phx.gbl...
> the job to fail.
> news:eVp7v$uTEHA.3988@.tk2msftngp13.phx.gbl...
> the
> that
> in
> The
> step 1
>

Maintenance Plan "fails"..

Thanks in advance for any insight.
On occasion, one of my schedule jobs will "fail", in that all tasks
complete, but it still reports failure. Strangely enough, nothing is written
to SQL Server log, but I do have the following entry in the Event Viewer:
"SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'Non-Great
Plains Daily Backup'' (0x01BF5D1C32E9FF418D67E99A77A4A014) - Status:
Failed - Invoked on: 2004-06-08 20:00:00 - Message: The job failed. The Job
was invoked by Schedule 35 (Schedule 1). The last step to run was step 1
(Step 1)."
Any ideas on how to troubleshoot this?
Thanks,
MorganAny messages in the report file? (Did you specify a report file, btw?)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Morgan" <abcd@.senditon.com> wrote in message news:eiY8NRjTEHA.1284@.TK2MSFTNGP10.phx.gbl...
> Thanks in advance for any insight.
> On occasion, one of my schedule jobs will "fail", in that all tasks
> complete, but it still reports failure. Strangely enough, nothing is written
> to SQL Server log, but I do have the following entry in the Event Viewer:
> "SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'Non-Great
> Plains Daily Backup'' (0x01BF5D1C32E9FF418D67E99A77A4A014) - Status:
> Failed - Invoked on: 2004-06-08 20:00:00 - Message: The job failed. The Job
> was invoked by Schedule 35 (Schedule 1). The last step to run was step 1
> (Step 1)."
> Any ideas on how to troubleshoot this?
>
> Thanks,
> Morgan
>|||Hi Tibor,
The only thing in the report file is that it was unable to delete one of the
database backups. Other than that, all of the steps completed. Would that
cause the job to think it failed?
Thanks,
Morgan
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ubeNMltTEHA.2544@.TK2MSFTNGP10.phx.gbl...
> Any messages in the report file? (Did you specify a report file, btw?)
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Morgan" <abcd@.senditon.com> wrote in message
news:eiY8NRjTEHA.1284@.TK2MSFTNGP10.phx.gbl...
> > Thanks in advance for any insight.
> >
> > On occasion, one of my schedule jobs will "fail", in that all tasks
> > complete, but it still reports failure. Strangely enough, nothing is
written
> > to SQL Server log, but I do have the following entry in the Event
Viewer:
> > "SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan
'Non-Great
> > Plains Daily Backup'' (0x01BF5D1C32E9FF418D67E99A77A4A014) - Status:
> > Failed - Invoked on: 2004-06-08 20:00:00 - Message: The job failed. The
Job
> > was invoked by Schedule 35 (Schedule 1). The last step to run was step 1
> > (Step 1)."
> >
> > Any ideas on how to troubleshoot this?
> >
> >
> > Thanks,
> >
> > Morgan
> >
> >
>|||If I wrote the code, yes a failed deletion of a backup file would cause the job to fail.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Morgan" <abcd@.senditon.com> wrote in message news:eVp7v$uTEHA.3988@.tk2msftngp13.phx.gbl...
> Hi Tibor,
> The only thing in the report file is that it was unable to delete one of the
> database backups. Other than that, all of the steps completed. Would that
> cause the job to think it failed?
> Thanks,
> Morgan
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:ubeNMltTEHA.2544@.TK2MSFTNGP10.phx.gbl...
> > Any messages in the report file? (Did you specify a report file, btw?)
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
> >
> >
> > "Morgan" <abcd@.senditon.com> wrote in message
> news:eiY8NRjTEHA.1284@.TK2MSFTNGP10.phx.gbl...
> > > Thanks in advance for any insight.
> > >
> > > On occasion, one of my schedule jobs will "fail", in that all tasks
> > > complete, but it still reports failure. Strangely enough, nothing is
> written
> > > to SQL Server log, but I do have the following entry in the Event
> Viewer:
> > > "SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan
> 'Non-Great
> > > Plains Daily Backup'' (0x01BF5D1C32E9FF418D67E99A77A4A014) - Status:
> > > Failed - Invoked on: 2004-06-08 20:00:00 - Message: The job failed. The
> Job
> > > was invoked by Schedule 35 (Schedule 1). The last step to run was step 1
> > > (Step 1)."
> > >
> > > Any ideas on how to troubleshoot this?
> > >
> > >
> > > Thanks,
> > >
> > > Morgan
> > >
> > >
> >
> >
>|||Ha! I hear ya. Would be nice if each piece of a maintenance plan could be a
seperate job, that way if deleting a previous days backup failed it wouldn't
look like the databases didn't get backed up since that would be a seperate
task with its own status.
Thanks,
Morgan
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:e3i9JIvTEHA.644@.tk2msftngp13.phx.gbl...
> If I wrote the code, yes a failed deletion of a backup file would cause
the job to fail.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Morgan" <abcd@.senditon.com> wrote in message
news:eVp7v$uTEHA.3988@.tk2msftngp13.phx.gbl...
> > Hi Tibor,
> >
> > The only thing in the report file is that it was unable to delete one of
the
> > database backups. Other than that, all of the steps completed. Would
that
> > cause the job to think it failed?
> >
> > Thanks,
> >
> > Morgan
> >
> >
> > "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in
> > message news:ubeNMltTEHA.2544@.TK2MSFTNGP10.phx.gbl...
> > > Any messages in the report file? (Did you specify a report file, btw?)
> > >
> > > --
> > > Tibor Karaszi, SQL Server MVP
> > > http://www.karaszi.com/sqlserver/default.asp
> > > http://www.solidqualitylearning.com/
> > >
> > >
> > > "Morgan" <abcd@.senditon.com> wrote in message
> > news:eiY8NRjTEHA.1284@.TK2MSFTNGP10.phx.gbl...
> > > > Thanks in advance for any insight.
> > > >
> > > > On occasion, one of my schedule jobs will "fail", in that all tasks
> > > > complete, but it still reports failure. Strangely enough, nothing is
> > written
> > > > to SQL Server log, but I do have the following entry in the Event
> > Viewer:
> > > > "SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan
> > 'Non-Great
> > > > Plains Daily Backup'' (0x01BF5D1C32E9FF418D67E99A77A4A014) - Status:
> > > > Failed - Invoked on: 2004-06-08 20:00:00 - Message: The job failed.
The
> > Job
> > > > was invoked by Schedule 35 (Schedule 1). The last step to run was
step 1
> > > > (Step 1)."
> > > >
> > > > Any ideas on how to troubleshoot this?
> > > >
> > > >
> > > > Thanks,
> > > >
> > > > Morgan
> > > >
> > > >
> > >
> > >
> >
> >
>|||A "hack" way is to create a script that does a "DIR" in the directory and delete old files. This can be done
using ActiveScript, TSQL of whatever is your preference...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Morgan" <abcd@.senditon.com> wrote in message news:OPwIwByTEHA.3480@.TK2MSFTNGP11.phx.gbl...
> Ha! I hear ya. Would be nice if each piece of a maintenance plan could be a
> seperate job, that way if deleting a previous days backup failed it wouldn't
> look like the databases didn't get backed up since that would be a seperate
> task with its own status.
> Thanks,
> Morgan
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:e3i9JIvTEHA.644@.tk2msftngp13.phx.gbl...
> > If I wrote the code, yes a failed deletion of a backup file would cause
> the job to fail.
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
> >
> >
> > "Morgan" <abcd@.senditon.com> wrote in message
> news:eVp7v$uTEHA.3988@.tk2msftngp13.phx.gbl...
> > > Hi Tibor,
> > >
> > > The only thing in the report file is that it was unable to delete one of
> the
> > > database backups. Other than that, all of the steps completed. Would
> that
> > > cause the job to think it failed?
> > >
> > > Thanks,
> > >
> > > Morgan
> > >
> > >
> > > "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
> in
> > > message news:ubeNMltTEHA.2544@.TK2MSFTNGP10.phx.gbl...
> > > > Any messages in the report file? (Did you specify a report file, btw?)
> > > >
> > > > --
> > > > Tibor Karaszi, SQL Server MVP
> > > > http://www.karaszi.com/sqlserver/default.asp
> > > > http://www.solidqualitylearning.com/
> > > >
> > > >
> > > > "Morgan" <abcd@.senditon.com> wrote in message
> > > news:eiY8NRjTEHA.1284@.TK2MSFTNGP10.phx.gbl...
> > > > > Thanks in advance for any insight.
> > > > >
> > > > > On occasion, one of my schedule jobs will "fail", in that all tasks
> > > > > complete, but it still reports failure. Strangely enough, nothing is
> > > written
> > > > > to SQL Server log, but I do have the following entry in the Event
> > > Viewer:
> > > > > "SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan
> > > 'Non-Great
> > > > > Plains Daily Backup'' (0x01BF5D1C32E9FF418D67E99A77A4A014) - Status:
> > > > > Failed - Invoked on: 2004-06-08 20:00:00 - Message: The job failed.
> The
> > > Job
> > > > > was invoked by Schedule 35 (Schedule 1). The last step to run was
> step 1
> > > > > (Step 1)."
> > > > >
> > > > > Any ideas on how to troubleshoot this?
> > > > >
> > > > >
> > > > > Thanks,
> > > > >
> > > > > Morgan
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>

Maint Plans

I created a Maintenence Plan, I tried to run them, but this error always makes then fail.
services. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029)
Whats up?
Thanks
Hi,
Do you run maintanace plan on default instance or named instance?
Check article's 326485 and 288577.
Regards.
"Robert Salazar" wrote:

> I created a Maintenence Plan, I tried to run them, but this error always makes then fail.
> services. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029)
> Whats up?
> Thanks
>

Maint Plans

I created a Maintenence Plan, I tried to run them, but this error always makes then fail.
services. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029)
Whats up?
ThanksHi,
Do you run maintanace plan on default instance or named instance?
Check article's 326485 and 288577.
Regards.
"Robert Salazar" wrote:
> I created a Maintenence Plan, I tried to run them, but this error always makes then fail.
> services. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029)
> Whats up?
> Thanks
>

Maint Plans

I created a Maintenence Plan, I tried to run them, but this error always mak
es then fail.
services. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029)
Whats up?
ThanksHi,
Do you run maintanace plan on default instance or named instance?
Check article's 326485 and 288577.
Regards.
"Robert Salazar" wrote:

> I created a Maintenence Plan, I tried to run them, but this error always m
akes then fail.
> services. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029)
> Whats up?
> Thanks
>

mail without mapi

Hi All,
I've got a SQL cluster in its own domain that I need to get notifications
from when the maintenance jobs fail. If I can't use an outlook mapi client
to send mail how can I get notified that jobs fail? Someone said I could use
SMTP mail but I don't know how to do this. Please help.
TIA!!
jj
Use xpsmtp from www.sqldev.net. I have used this in clustered environments
for a long time and have had zero problems.
Geoff N. Hiten
Microsoft SQL Server MVP
"jj" <jeff_detoro@.urmc.rochester.edu> wrote in message
news:OcWeEBAeFHA.584@.TK2MSFTNGP15.phx.gbl...
> Hi All,
> I've got a SQL cluster in its own domain that I need to get notifications
> from when the maintenance jobs fail. If I can't use an outlook mapi client
> to send mail how can I get notified that jobs fail? Someone said I could
> use SMTP mail but I don't know how to do this. Please help.
> TIA!!
> jj
>

mail without mapi

Hi All,
I've got a SQL cluster in its own domain that I need to get notifications
from when the maintenance jobs fail. If I can't use an outlook mapi client
to send mail how can I get notified that jobs fail? Someone said I could use
SMTP mail but I don't know how to do this. Please help.
TIA!!
jjUse xpsmtp from www.sqldev.net. I have used this in clustered environments
for a long time and have had zero problems.
Geoff N. Hiten
Microsoft SQL Server MVP
"jj" <jeff_detoro@.urmc.rochester.edu> wrote in message
news:OcWeEBAeFHA.584@.TK2MSFTNGP15.phx.gbl...
> Hi All,
> I've got a SQL cluster in its own domain that I need to get notifications
> from when the maintenance jobs fail. If I can't use an outlook mapi client
> to send mail how can I get notified that jobs fail? Someone said I could
> use SMTP mail but I don't know how to do this. Please help.
> TIA!!
> jj
>

mail without mapi

Hi All,
I've got a SQL cluster in its own domain that I need to get notifications
from when the maintenance jobs fail. If I can't use an outlook mapi client
to send mail how can I get notified that jobs fail? Someone said I could use
SMTP mail but I don't know how to do this. Please help.
TIA!!
jjUse xpsmtp from www.sqldev.net. I have used this in clustered environments
for a long time and have had zero problems.
Geoff N. Hiten
Microsoft SQL Server MVP
"jj" <jeff_detoro@.urmc.rochester.edu> wrote in message
news:OcWeEBAeFHA.584@.TK2MSFTNGP15.phx.gbl...
> Hi All,
> I've got a SQL cluster in its own domain that I need to get notifications
> from when the maintenance jobs fail. If I can't use an outlook mapi client
> to send mail how can I get notified that jobs fail? Someone said I could
> use SMTP mail but I don't know how to do this. Please help.
> TIA!!
> jj
>

mail client and dts send mail task

Hi,
Is it required to have microsoft outlook client up-and-running to send mail from dts package?
I have a dts package which send email if job fail or success. will it work fine if someone by mistek close outlook client running on server?
please reply.
Ram.No, the outlook client does not have to be running to use send-mail in a dts package.

The outlook client needs to be installed on the server and the profile needs to be created for the user context that will be running the dts package.

Here is where the confusion typically lies. When you run a DTS package interactively, the security context is who-ever you are logged in as. As such, it is relatively easy to debug. What most people don't understand is that if the DTS package is running based on some automated feature (timer, or another application starting it) the DTS package typically runs under the SQL Agent ID (Check the logon-id of the user that starts SQL Agent in control panel Services). You will need to use a specific ID, rather than system. This is because to use SQL Mail, you will have to interactively log-on as that user and configure outlook. Once you have done that, the SQL Agent will be able to send and receive e-mail without you being logged in.

Good luck.|||Originally posted by rmillman
No, the outlook client does not have to be running to use send-mail in a dts package.

The outlook client needs to be installed on the server and the profile needs to be created for the user context that will be running the dts package.

Here is where the confusion typically lies. When you run a DTS package interactively, the security context is who-ever you are logged in as. As such, it is relatively easy to debug. What most people don't understand is that if the DTS package is running based on some automated feature (timer, or another application starting it) the DTS package typically runs under the SQL Agent ID (Check the logon-id of the user that starts SQL Agent in control panel Services). You will need to use a specific ID, rather than system. This is because to use SQL Mail, you will have to interactively log-on as that user and configure outlook. Once you have done that, the SQL Agent will be able to send and receive e-mail without you being logged in.

Much thanks for your reply. explains me how dts send email . nothing to do with up-and-running mail client . it sends email internally useing agent.
cool.

Good luck.|||There's a great email extended procedure you can get that will allow you to send email without installing the outlook client on all your SQL servers. You can go this link for details: http://sqldev.net/xp/xpsmtp.htm

We have implemented this at LexisNexis by writing a wrapper procedure that calls the extended procedure. This provides a higher level security. You can call this from within a DTS package or via a job step within a scheduled job. We've been using this for quiet awhile with great success in all our maintenance plans for backups.