all groups > sql server dts > july 2007 >
You're in the

sql server dts

group:

Copy database problem


Copy database problem Woody
7/26/2007 7:34:06 AM
sql server dts:
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.JobBaseCollection' 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 Studio 9.00.1399.00
Microsoft Analysis Services Client Tools 2005.090.1399.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00
(xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 7.0.5730.11
Microsoft .NET Framework 2.0.50727.832
Operating System 5.1.2600



Re: Copy database problem Woody
7/31/2007 11:54:03 AM
Thank you for responding. It was so long ago that I posted the question I
was afraid it wasn't going to get answered. But getting SP_2 solved the
problem.

Thank you again.

[quoted text, click to view]
Re: Copy database problem JPD
7/31/2007 3:28:39 PM
Hi,

There have been some issues with the copy database wizard. I would
suggest that you upgrade to at least SP2 and perhaps the latest build.

Jonathan



[quoted text, click to view]
AddThis Social Bookmark Button