Trying to Copy DB and getting Error

15 Dec 2005 9:23 AM

Doug Handler

Hi,

I'm trying to "copy" a DB w/i 2k5 and when the wizard goes to execute my
request, i get an error "No such interfacess supported." No details are
provided, just this message. I'm unsure what it means or how to resolve it.
SQL Server Agent is running and everything seems fine.

All i want to do is create a New DB and change tablenames and fieldnames w/o
loosing the data. Is there a different, better way to do this?

dh

16 Dec 2005 4:03 PM

Andrew J. Kelly

Do a restore of the full backup for the original db and give it a different
name and physical file names or locations. Then you can edit the objects
all you want.

--
Andrew J. Kelly SQL MVP

Show quote

"Doug Handler" <dkhand***@yahoo.com> wrote in message
news:%236qnOlVAGHA.3268@TK2MSFTNGP10.phx.gbl...
> Hi,
>
> I'm trying to "copy" a DB w/i 2k5 and when the wizard goes to execute my
> request, i get an error "No such interfacess supported." No details are
> provided, just this message. I'm unsure what it means or how to resolve
> it. SQL Server Agent is running and everything seems fine.
>
> All i want to do is create a New DB and change tablenames and fieldnames
> w/o loosing the data. Is there a different, better way to do this?
>
> dh
>