INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Maintenance plan still references deleted databases on SQL Server 2005 SP2

Maintenance plan still references deleted databases on SQL Server 2005 SP2

(OP)
I have been dealing with the mystery of a non-existent database that the daily maintenance plan tries to backup. The plan obviously fails, database and log. There is a weekly plan than runs on Sundays; this one completes successfully.

We are running SQL Server 2005 Standard Edition SP2. I learned today that in SP2, the maintenance plans script is not updated to reflect that a database has been deleted and that SP3 takes care of the issue. A solution could be to recreate the plan altogether (I have tried updating and saving it to no avail). Since we are two SPs behind, I guess the best choice is to update the servers. Have you ever dealt with this issue before? If yes how did you solve it? Also, should I be aware of anything while updating the SP on the server?

Thanks for your help.

MCP SQL Server 2000, MCTS SQL Server 2005, MCTS SQL Server 2008 (DBD, DBA)

RE: Maintenance plan still references deleted databases on SQL Server 2005 SP2

I actually had the same issue as well as another with cleaning up database backup files. After doing research which indicated that it was a bug that was resolved in the latest service pack. I installed service pack 4. I went from SQL Server 2005 SP2 to SQL Server 2005 SP4 and it resolved both issues. Service pack 4 installed with no problems.

With Great Power Comes Great Responsibility!!! afro

Michael

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close