database backup maintenance plan

Question

database backup maintenance plan

sreedevi_c

SSC Veteran

Points: 213
More actions
August 1, 2009 at 10:41 am

#212770

have a database maintenance plan that has been migrated from SQLserver 2000 to 2005.
This is a backup plan.
We recently removed few databases from this server.
We have modified the plan accordinly.But still the plan fails.
It backsup all the databases and also still tries to backup the removed databases and finally says the job failed.
The plan history shows an error number :62309

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

MartinSchmidt Mr or Mrs. 500 Points: 525 More actions · Answer 1

Not sure this is the answer you are looking for, but anyway.

I would delete the plan and create a new one, the time you spend on troubleshooting is way bigger than the time is takes to make ned plan

/mSc

Jeff Moden SSC Guru Points: 1004339 More actions · Answer 2

Yep... I agree with that.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

ChiragNS One Orange Chip Points: 26137 More actions · Answer 3

and what if the same thing happens again.

"Keep Trying"

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 4

Hopefully they are not removing databases regularly. the plans don't modify well, so if this is a regular problem, I'd stop using the "all user databases" and check each database. You have to remember to check the plan again after adding a db, but I'd make that part of your maintenance.