Backup job failed but Backup operation is completed and succeeded.

[Yee Beng]

Hi,

I'm using SQL Server 2005 Standard Edition SP 2 (9.0.3257) on Windows 2003
Enterprise Edition SP2.

I am currently facing the issue bellow which i think it's interrelated.

I created a backup transaction log plan from SQL server management studio
(SSMS) by right clicking "maintenance plan" folder -> create new maintenance
plan.

First issue i attempted is that after i created the plan, i refreshed the
maintenance plan folder in SSMS. however there is no plan listed under the
"maintenance plan" folder. no matter how many plans i created. none of it
listed there. But i manage to see the job created under "Job Activity
monitor".

Second issue is that ,I initiated the Job to run from Job Activity Monitor,
however the job status was "FAILED". But when i checked on the system tables
"msdb.dbo.sysmaintplan_log" and "msdb.dbo.sysmaintplan_logDetail", i notice
that the backup transaction log was successfully executed. I cannot locate
the Log Files that sql server will log whenever the backup operation fail or
success on the default directories "\Program Files\Microsoft SQL
server\MSSQL.1\MSSQL\LOG\". i dunno what has gone wrong with sql server. The
only Error message i can get is from Job history, as shown in the following:

Error: 2009-01-20 12:03:45.06 Code: 0xC0024104 Source: Reporting Task for
subplan-{2FE1C3BA-E3B2-4E6D-B60C-7A4A32896A73}
Description: The Execute method on the task returned error code 0x80004003
(Object reference not set to an instance of an object.). The Execute method
... The package execution fa... The step failed.

Can anyone please help??

TIA

[Uri Dimant]

Yee Beng
Check if the account the SQL Server Agent runs under has a permission to
write to the path you specified, also check if the database is not set up
SIMPLE recovery model

Post by Yee Beng
Hi,
I'm using SQL Server 2005 Standard Edition SP 2 (9.0.3257) on Windows 2003
Enterprise Edition SP2.
I am currently facing the issue bellow which i think it's interrelated.
I created a backup transaction log plan from SQL server management studio
(SSMS) by right clicking "maintenance plan" folder -> create new maintenance
plan.
First issue i attempted is that after i created the plan, i refreshed the
maintenance plan folder in SSMS. however there is no plan listed under the
"maintenance plan" folder. no matter how many plans i created. none of it
listed there. But i manage to see the job created under "Job Activity
monitor".
Second issue is that ,I initiated the Job to run from Job Activity Monitor,
however the job status was "FAILED". But when i checked on the system tables
"msdb.dbo.sysmaintplan_log" and "msdb.dbo.sysmaintplan_logDetail", i notice
that the backup transaction log was successfully executed. I cannot locate
the Log Files that sql server will log whenever the backup operation fail or
success on the default directories "\Program Files\Microsoft SQL
server\MSSQL.1\MSSQL\LOG\". i dunno what has gone wrong with sql server. The
Error: 2009-01-20 12:03:45.06 Code: 0xC0024104 Source: Reporting Task for
subplan-{2FE1C3BA-E3B2-4E6D-B60C-7A4A32896A73}
Description: The Execute method on the task returned error code 0x80004003
(Object reference not set to an instance of an object.). The Execute method
... The package execution fa... The step failed.
Can anyone please help??
TIA

[Yee Beng]

Hi Uri,

It's run under local system, the DB is in Full recovery.

Post by Uri Dimant
Yee Beng
Check if the account the SQL Server Agent runs under has a permission to
write to the path you specified, also check if the database is not set up
SIMPLE recovery model

Post by Yee Beng
Hi,
I'm using SQL Server 2005 Standard Edition SP 2 (9.0.3257) on Windows 2003
Enterprise Edition SP2.
I am currently facing the issue bellow which i think it's interrelated.
I created a backup transaction log plan from SQL server management studio
(SSMS) by right clicking "maintenance plan" folder -> create new maintenance
plan.
First issue i attempted is that after i created the plan, i refreshed the
maintenance plan folder in SSMS. however there is no plan listed under the
"maintenance plan" folder. no matter how many plans i created. none of it
listed there. But i manage to see the job created under "Job Activity
monitor".
Second issue is that ,I initiated the Job to run from Job Activity Monitor,
however the job status was "FAILED". But when i checked on the system tables
"msdb.dbo.sysmaintplan_log" and "msdb.dbo.sysmaintplan_logDetail", i notice
that the backup transaction log was successfully executed. I cannot locate
the Log Files that sql server will log whenever the backup operation fail or
success on the default directories "\Program Files\Microsoft SQL
server\MSSQL.1\MSSQL\LOG\". i dunno what has gone wrong with sql server. The
Error: 2009-01-20 12:03:45.06 Code: 0xC0024104 Source: Reporting Task for
subplan-{2FE1C3BA-E3B2-4E6D-B60C-7A4A32896A73}
Description: The Execute method on the task returned error code 0x80004003
(Object reference not set to an instance of an object.). The Execute method
... The package execution fa... The step failed.
Can anyone please help??
TIA

[Uri Dimant]

Hi
I agree with Tibor to check out the Error.log file. What is the service pack
do you have?

Post by Yee Beng
Hi Uri,
It's run under local system, the DB is in Full recovery.

Post by Uri Dimant
Yee Beng
Check if the account the SQL Server Agent runs under has a permission to
write to the path you specified, also check if the database is not set up
SIMPLE recovery model

Post by Yee Beng
Hi,
I'm using SQL Server 2005 Standard Edition SP 2 (9.0.3257) on Windows 2003
Enterprise Edition SP2.
I am currently facing the issue bellow which i think it's interrelated.
I created a backup transaction log plan from SQL server management studio
(SSMS) by right clicking "maintenance plan" folder -> create new maintenance
plan.
First issue i attempted is that after i created the plan, i refreshed the
maintenance plan folder in SSMS. however there is no plan listed under the
"maintenance plan" folder. no matter how many plans i created. none of it
listed there. But i manage to see the job created under "Job Activity
monitor".
Second issue is that ,I initiated the Job to run from Job Activity Monitor,
however the job status was "FAILED". But when i checked on the system tables
"msdb.dbo.sysmaintplan_log" and "msdb.dbo.sysmaintplan_logDetail", i notice
that the backup transaction log was successfully executed. I cannot locate
the Log Files that sql server will log whenever the backup operation
fail
or
success on the default directories "\Program Files\Microsoft SQL
server\MSSQL.1\MSSQL\LOG\". i dunno what has gone wrong with sql
server.
The
Error: 2009-01-20 12:03:45.06 Code: 0xC0024104 Source: Reporting Task for
subplan-{2FE1C3BA-E3B2-4E6D-B60C-7A4A32896A73}
Description: The Execute method on the task returned error code 0x80004003
(Object reference not set to an instance of an object.). The Execute method
... The package execution fa... The step failed.
Can anyone please help??
TIA

[Tibor Karaszi]

Consider checking the errorlog file for messages from the database
engine regarding successful or failed backup completion. Just as one
part to the picture.

I would investigate whether there is something fishy with your
Integration Services installation. Your problem smells to me like it
is SSIS which has problems, and the problems is not at the DBMS
level...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

Post by Yee Beng
Hi,
I'm using SQL Server 2005 Standard Edition SP 2 (9.0.3257) on
Windows 2003
Enterprise Edition SP2.
I am currently facing the issue bellow which i think it's
interrelated.
I created a backup transaction log plan from SQL server management studio
(SSMS) by right clicking "maintenance plan" folder -> create new maintenance
plan.
First issue i attempted is that after i created the plan, i
refreshed the
maintenance plan folder in SSMS. however there is no plan listed under the
"maintenance plan" folder. no matter how many plans i created. none of it
listed there. But i manage to see the job created under "Job
Activity
monitor".
Second issue is that ,I initiated the Job to run from Job Activity Monitor,
however the job status was "FAILED". But when i checked on the
system tables
"msdb.dbo.sysmaintplan_log" and "msdb.dbo.sysmaintplan_logDetail", i notice
that the backup transaction log was successfully executed. I cannot locate
the Log Files that sql server will log whenever the backup operation fail or
success on the default directories "\Program Files\Microsoft SQL
server\MSSQL.1\MSSQL\LOG\". i dunno what has gone wrong with sql server. The
Error: 2009-01-20 12:03:45.06 Code: 0xC0024104 Source: Reporting Task for
subplan-{2FE1C3BA-E3B2-4E6D-B60C-7A4A32896A73}
Description: The Execute method on the task returned error code 0x80004003
(Object reference not set to an instance of an object.). The Execute method
... The package execution fa... The step failed.
Can anyone please help??
TIA