Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / General / Other SQL Server Topics / July 2007

Tip: Looking for answers? Try searching our database.

Copy database problem

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Woody - 27 Jul 2007 21:52 GMT
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
Sue Hoegemeier - 30 Jul 2007 00:55 GMT
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

>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
[quoted text clipped - 18 lines]
>Microsoft .NET Framework                        2.0.50727.832
>Operating System                        5.1.2600
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.