Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 DB Maintenance Plans

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-04-18 : 09:24:29
Brian writes "Hi,
Even if one logs on using Windows Authentication and restores a DB of a previous MS SQL Version, the DB doesn’t appear in the list for Database Maintenance Plans.

I've tried changing the DB compatibility level after restoring the db from the earlier version's backup to convert it to a native SQL 2005 db but I still don't see the Maintainence Plan.

What is the solution to this problem?

NB: I'm using the developer version of MS SQL Server 2005"
   

- Advertisement -