Monday, March 19, 2012

Copy database problem

I am running SQL Server 2005 and trying to make a copy of a database from
Management Studio. Using the Backup wizard I go through all the steps that
you would normally walk through to make a copy, and actually start the copy,
but when I do I get the following error message from the copy database wizard.
"Could not load type
'Microsoft.SqlServer.Management.Smo.Agent.JobBaseC ollection' from assembly
'Microsoft.SqlServer.Smo, Version=9.0.242.0, Culture = neutral, Public Token
= xxxx..."
Could somone tell me what the problem is and how to correct it?
My SS version numbers etc follow:
Microsoft SQL Server Management Studio9.00.1399.00
Microsoft Analysis Services Client Tools2005.090.1399.00
Microsoft Data Access Components (MDAC)2000.085.1117.00
(xpsp_sp2_rtm.040803-2158)
Microsoft MSXML2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer7.0.5730.11
Microsoft .NET Framework2.0.50727.832
Operating System5.1.2600
The same error has been fixed for a couple of people by
applying SP2 - to the server and the client. You would
probably want to start with that approach.
-Sue
On Fri, 27 Jul 2007 13:52:02 -0700, Woody
<Woody@.discussions.microsoft.com> wrote:

>I am running SQL Server 2005 and trying to make a copy of a database from
>Management Studio. Using the Backup wizard I go through all the steps that
>you would normally walk through to make a copy, and actually start the copy,
>but when I do I get the following error message from the copy database wizard.
>"Could not load type
>'Microsoft.SqlServer.Management.Smo.Agent.JobBase Collection' from assembly
>'Microsoft.SqlServer.Smo, Version=9.0.242.0, Culture = neutral, Public Token
>= xxxx..."
>Could somone tell me what the problem is and how to correct it?
>My SS version numbers etc follow:
>Microsoft SQL Server Management Studio9.00.1399.00
>Microsoft Analysis Services Client Tools2005.090.1399.00
>Microsoft Data Access Components (MDAC)2000.085.1117.00
>(xpsp_sp2_rtm.040803-2158)
>Microsoft MSXML2.6 3.0 4.0 5.0 6.0
>Microsoft Internet Explorer7.0.5730.11
>Microsoft .NET Framework2.0.50727.832
>Operating System5.1.2600
>

No comments:

Post a Comment