COPY DATABASE WIZARD

Hello,

I have been trying to use the Copy Database wizard, once I get through all the steps of defining the databases to use and hit finish (using SMO transfer), I get an

'Copy Database : No such interface supported'

Error and the action terminates! How can I fix this?

Regards

I am assuming you are copying both from and to SQL 2005 based databases? Not sure if Copy DB Wizard will support DMO for the older sql2000 servers.|||

Hi Raaj,

Please take a look at the existing CDW Feedback issues and either add your comments to a related one you see, or post a new Feedback Defect with the following information:

1. Source and destination server versions (8.0 or Yukon), including Service Packs.

2. Whether SQL Agent is running on either source and/or destination, and what version.

3. Whether 8.0 QA is installed on either machine.

4. A repro database attached, to either sp_attach or as a script to run. The smaller the better as long as it exhibits the problem.

We are working on CDW issues for SQL Server 2005 SP2, and are very interested in having good coverage on issues such as yours.

Ed Dudenhoefer

SQL Server Team

sqlsql

COPY DATABASE WIZARD

Hello,

I have been trying to use the Copy Database wizard, once I get through all the steps of defining the databases to use and hit finish (using SMO transfer), I get an

'Copy Database : No such interface supported'

Error and the action terminates! How can I fix this?

Regards

I am assuming you are copying both from and to SQL 2005 based databases? Not sure if Copy DB Wizard will support DMO for the older sql2000 servers.|||

Hi Raaj,

Please take a look at the existing CDW Feedback issues and either add your comments to a related one you see, or post a new Feedback Defect with the following information:

1. Source and destination server versions (8.0 or Yukon), including Service Packs.

2. Whether SQL Agent is running on either source and/or destination, and what version.

3. Whether 8.0 QA is installed on either machine.

4. A repro database attached, to either sp_attach or as a script to run. The smaller the better as long as it exhibits the problem.

We are working on CDW issues for SQL Server 2005 SP2, and are very interested in having good coverage on issues such as yours.

Ed Dudenhoefer

SQL Server Team

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
>