The error "System.Runtime.InteropServices.COMException" appears when trying to copy a SQL Server database over an existing database.
Steps to reproduce:
1. Open Toad for SQL Server and connect to the database.
2. Select the Database to copy.
3. Set the destination database (make sure it already exists in the database)
4. Set the database file name (make sure it already exists in the database)
5. Check "Overwrite any existing files"
6. Go
********************************************************************************
Exception Information
********************************************************************************
Exception: System.Runtime.InteropServices.COMException
Message : Retrieving the COM class factory for component with CLSID {10020200-EB1C-11CF-AE6E-00AA004A34D5} failed due to the following error: 80040154.
Stack Trace:
at Quest.Toad.SqlServer.Doe.CopyMoveDBWizard.Objects.Server.GetResultConnectionToSoursceServer(WizardParams options)
at Quest.Toad.SqlServer.Doe.CopyMoveDBWizard.CopyMoveDBWizard.pageConfigureDTSPackages_CloseFromNext(Object sender, PageEventArgs e)
at Quest.Toad.Controls.Wizard.WizardPage.OnCloseFromNext(Wizard wiz)
at Quest.Toad.Controls.Wizard.Wizard.Next()
at Quest.Toad.Controls.Wizard.Wizard.btnNext_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at DevExpress.XtraEditors.BaseButton.OnClick(EventArgs e)
at DevExpress.XtraEditors.BaseButton.OnMouseUp(MouseEventArgs e)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at DevExpress.Utils.Controls.ControlBase.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Messa
WORKAROUND:
None
STATUS:
Waiting for fix in a future release of Toad for SQL Server
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center