May 28, 2008 at 4:29 pm
Hello, My @@version is Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
My problem is that only some of the databases are visible thru the maintenance plan GUI - ie right-click maintenance plan, new maintance plan, shrink database, etc.
The model, msdb, master, Adventure Works, etc are visible for selection, plus some of the locally created databases, but NOT ALL of them.
Has someone seen this before?
May 28, 2008 at 8:05 pm
Haven't seen that. The task should call some sys.databases, so if the account can see the databases in that view, they should come through.
Not sure why you wouldn't see them. Are you building the maintenance plan as an admin?
May 29, 2008 at 10:38 am
ron (5/28/2008)
Has someone seen this before?
Only when a database is unavailable/offline...
"Got no time for the jibba jabba!"
-B.A. Baracus
May 29, 2008 at 12:34 pm
I am logged on as the sa user with full admin rights.
June 14, 2008 at 8:06 am
I had the same problem and solved it. To be seen in the Databases while creating a Maintenance Plan, your database must have the compatibility level of SQL Server 2005 (90).
Mine was a restore of a backup from an SQL Server 7.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply