February 9, 2008 at 11:01 am
Hi!
I have a problem with one database creating a maintenance plan.
I can choose to backup nearly all databases, but not the one I want to.
When I run the maintenance-Plan-wizard, nearly all databases are listet to select, but my important database ist not in the list - see my attachment.
This database ist imported from another sql-server and is running very good - all other functions are correct and manual backups are simply OK.
The password from the sa ist the same as on the previous db-server.
Can You help me or give a hint?
With kind regards
Mark from Vienna
February 10, 2008 at 9:12 am
I believe that list is populated from sys.databases, so if it's in there, it should be there.
However it's possible there's some ownership problem. Who owns the new database?
The image doesn't help. We don't know which database is which.
February 10, 2008 at 11:32 am
You might be able to find out whats going wrong using a trace.
Use "Errors and Warnings" -> Exceptions in the events selection.
I had an issue with a maint plan today where the plan was running fine, but the job was failing.
The trace reveiled errors while accessing a user database (that was not included in the plan).
After removing the DB, the job also succeeded.
Good Luck!
Best Regards,
Chris Büttner
February 11, 2008 at 7:37 am
I had this problem as well. My problem was that I was running SQL Server 2005, but the database I wanted to create maintenance plans for had a compatibility level of SQL Server 7.0. Due to application requirements I was unable to change the compatibility level so I had to run manual backups and maintenance tasks.
February 14, 2008 at 1:07 pm
Thank You - this was the problem!
Kind regards
Mark
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply