SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Database '' is not valid to be included in the maintenance plan.


Database '' is not valid to be included in the maintenance plan.

Author
Message
Steve Park
Steve Park
SSC Rookie
SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)

Group: General Forum Members
Points: 45 Visits: 34
I am receiving the "Database '' is not valid to be included in the maintenance plan." when backing up the transaction logs of selected databases. The weird thing is the databases that are getting the error are not on that server or included in the maintenance plan. I do not have any snap shots either. And I have verified that all databases are compatibility level >80.

Thanks,

Steve
PaulB-TheOneAndOnly
PaulB-TheOneAndOnly
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14161 Visits: 4639
Lets pretend I didn't read the part about affected databases not being part of that server.

Is the offending Maintenance Plan set up to backup "All Databases"?

if this is the case try selecting User database individually.

_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Steve Park
Steve Park
SSC Rookie
SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)

Group: General Forum Members
Points: 45 Visits: 34
No the maintenance plan is set to backup the transaction logs of only selected databases, not all databases. And the databases affected were removed from the server a while ago.
Jeffrey Williams 3188
Jeffrey Williams 3188
SSCoach
SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)

Group: General Forum Members
Points: 19161 Visits: 10042
When those databases were removed, was the maintenance plan modified to remove the old databases?

Jeffrey Williams
Problems are opportunities brilliantly disguised as insurmountable obstacles.

How to post questions to get better answers faster
Managing Transaction Logs

Steve Park
Steve Park
SSC Rookie
SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)

Group: General Forum Members
Points: 45 Visits: 34
Not sure, since I didn't remove them. However I would have figured that if a database was removed then it would cascade to the maintenance plans. However I guess not. I am going to try to remove the maintenance plan and recreate it to see if that fixes the errors.
Jeffrey Williams 3188
Jeffrey Williams 3188
SSCoach
SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)

Group: General Forum Members
Points: 19161 Visits: 10042
Steve Park (5/7/2009)
Not sure, since I didn't remove them. However I would have figured that if a database was removed then it would cascade to the maintenance plans. However I guess not. I am going to try to remove the maintenance plan and recreate it to see if that fixes the errors.


No - don't remove the maintenance plan. Just modify each task and re-save it to update the list of databases. When you create a maintenance plan, and select a set of databases - that set is saved in the plan. Removing a database does not 'cascade' - so the original maintenance plan is trying to backup a database that no longer exists.

Like I said - just open the task and resave the plan. That should remove the old databases.

Jeffrey Williams
Problems are opportunities brilliantly disguised as insurmountable obstacles.

How to post questions to get better answers faster
Managing Transaction Logs

monrroym
monrroym
SSC Rookie
SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)

Group: General Forum Members
Points: 26 Visits: 3
Hi Jeffrey,

I have a similar scenario: One of my full backup Jobs is failing because a database was deleted by one of the share point administrators who notified me (the DBA) after he had already deleted the database, which is still displaying in the 'backup database task' for the maintenance plan but it no longer displays in the 'Specific Databases' list for me to deselect. Which msdb table holds the specific list of databases to be backed up for the 'backup database task'? I must be able to execute a script to delete this this particular database. Help!

Thanks,

M Morales
GilaMonster
GilaMonster
SSC Guru
SSC Guru (224K reputation)SSC Guru (224K reputation)SSC Guru (224K reputation)SSC Guru (224K reputation)SSC Guru (224K reputation)SSC Guru (224K reputation)SSC Guru (224K reputation)SSC Guru (224K reputation)

Group: General Forum Members
Points: 224542 Visits: 46317
monrroym (9/17/2014)
Which msdb table holds the specific list of databases to be backed up for the 'backup database task'?


None. Maint plans are SSIS packages. Follow the advice above about re-saving the plan. You should be able to toggle the list to 'all databases', save, then back to specific ones, select the ones you want and save again.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass


monrroym
monrroym
SSC Rookie
SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)

Group: General Forum Members
Points: 26 Visits: 3
Yes, re-saving the maintenance plan with the new list of specific databases did the trick.

Thank you so much :-)

M Morales
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search