@ alvin

In the system configuration check,

there is 1 warning for minimum hardware requirement:-

The current hardware requiremnt does not meet the release for this sql server version

Regards,

Sushant

I removed the sql 2005 instance and again re installed it

Just the sql server database services and the reporting services failed, other services were installed.

and as a result i...

@ cirqued

How to make sure

im just installing the sql 2005 setup.exe

when it asks default instance or named instance, whcih should i choose?

Regards,

Sushant

do i need to run upgrade advisor again ?

Regards,

Sushant

I guess, i installed a new instance

shld i delete sql 2005 and start again?

@homebrew and cirquedeSQL are correct

Other basic things u can check are

*Deleting the olderr backup files if the disk space falls below 40%(checking all servers disk space too)

*Checking...

@ ninja

But when I run this sp manually (in SSMS), it runs fine...

So i should change the @poprctnm as varchar(40) to varchar(50)?? in case the column width have to be...

@jinesh

No one deleted the database,

the sql server version is 9.00.4053.00 SP3 standard edition

@ YTZ

Ya, i checked the database size of previous backups

there is not much difference.

I guess some verifying backup integrity or maintenance plan failed

Regards,

Sushant

@YTZ

I am getting the output as 1 0 2 0 respectively

for on_success_action

on_success_step_id

on_fail_action

on_fail_step_id

Regards,

Sushant

@ashish

maintenenance plan is sql task

Im in sql server 2005 enterprise edition

@david-2

maintenance plan history doesnt show any error.

it says 1st step took 7 min and 2nd step 0 secs.

Regards,

Sushant

@ YTZ

For both step, the run_status are 0

the error for 1st step i mentioned earlier and the error for the other step is :-

The job failed. The Job was...

@ashish

The error which I posted, I got from expanding the job only.

No where it mentions that maintenence cleanup task has failed.

Regards,

Sushant

@ ashish

Ya, after the backup, there is maintenance cleanup task, which cleans up the older files. That is the second and last step.

But, where is it mentioned that this step...