@ ashish

Ya, I have to delete it manually everyday.

I am able to delete it.

Regards,

Sushant

@ ashish

No, im not copying the db, I m directly backing up the database to that destination.

Regards,

Sushant

@jeffrey

The two tasks r connected such as ... if the backup succeeds then the maintenenace plan should clean up older files.

The directory in maintenenace plan is the same as specified...

@ steve

There is only option of report to a text file in the mainteneance plan which i pasted earlier.

In the job properties there is option of write to the windows...

@ sqlbuddy

I am backing just 1 database into a folder, that is the one which is not getting deleted.

btw, the extension for the deletion should be bak or .bak ??

Regards,

Sushant

@ sql buddy

If the agent didn't had access to the backup directory, then how could the backup be placed everyday?.... correct me if iam wrong

The backup happens everyday but...

@sqlbuddy

The output is :

NEW COMPONENT OUTPUT

Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.4053

Report was generated on "server name".

Maintenance Plan: job_name@10pm

Duration: 00:00:00

Status: Succeeded.

Details:

Regards,

Sushant

@sqlbuddy

wats MP logs?

are you referring sql server logs??

Regards,

Sushant

@ nj- dba

Its

9.00.4053.00 SP3 Standard edition

@NJ-dba

The version is windows server 2003 with sp2

the file extension i mentioned is bak

@steve-2

Windows server 2003 with sp2

The delete settings are :-

Delete files with extension bak and older...

@NJ-DBA

I tried to copy the .bak file to destination server earlier, it was completed, but when I started the restoring via the SSMS restore database, GUI informed that the backup...

@ pradeep adiga

Wow

gr8 script

Regards,

Sushant

@ alvin & cirqued

Thxs a lot guyz

Actually, the instance name i earlier put was sql server agent name(diff from sql server)

I guess that was the mistake

Regards,

Sushant

BVI

@ all

The upgradation was successful

I guess made a mistake in naming the instance name

after i changed it, everything was smooth.

Thanks all for helping me

Regards,

Sushant

@ alvin

It doesn't specify

but my hardware meets the sql 2005 requirements

It has 512 MB RAM

2.5GHZ

windows server 2003 enterprise edition sp1