Hello Group,

We were running SQL2000 and upgraded to SQL2005. After backing up our
databases to a remote HD and restoring them onto SQL2005 I can no longer run
a maintenance plan against the restored databases. For a test I created a
test database and used the maintenance plan wizard to create the backup plan.
When I execute the plan it works fine on the newly created test database. I
have been looking and looking for the reason for the failures against the
restored database’s but just can’t pin it down. So I’m hoping someone can
help out with my problem.

Thanks,
Rick Morgan

Is the compatibility mode set to 80 or still at 70?

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Rick" <Rick (AT) discussions (DOT) microsoft.com> wrote

It is set to 70.

"Andrew J. Kelly" wrote:

I set it to 80 and tried it failed. Here is part of the error.

Error: 2009-05-10 21:32:19.71 Code: 0xC001000E Source:
Description: The connection "{AFB82EF1-9A11-409C-81B1-9178A8A320C5}" is not
found. This error is thrown by Connections collection when the specific
connection element is not found. End Erro

I am a little lost on exactly what you are doing. Did you restore MSDB as
well and is this a maintenance plan that was created on the 2000 server?
The 2000 plans are considered legacy and should be totally redone from
scratch using the new 2005 MP.


--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Rick" <Rick (AT) discussions (DOT) microsoft.com> wrote

Rick (Rick (AT) discussions (DOT) microsoft.com) writes:
There was a little confusion in Andy's post. 70 is for SQL 7, 80 is the
mode for SQL 2000. The compatibility level for SQL 2005 is 90. However:

This error does not look like something that could depend on the
compat level.





--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx