MS SQL Server Tools - Error running Copy Database Wizard (CDW)

Author

Error running Copy Database Wizard (CDW)

Christos Kritikos

2005-03-30, 7:04 pm

Hello,

I am using the Copy Database Wizard (CDW) to copy a database from one SQL
server to another. Unfortunately I get the following error:
Failed to copy file \\Servername\OMWWIZD
\SQL2000\MSSQL\Data\
dbname.MDF

I went through KB 274463 and this sort of error is not mentioned. All the
possible problematic steps mentioned in the article work fine:
- the share (OMWWIZD) is created successfully
- the database gets detached
- all logins, DTS's etc get copied fine
However the actual MDF file cannot be copied.

My configuration is as follows
Source: Win2000 Std Server w/ all updates
Destination: Win2003 Std Server w/ all updates
Both SQL servers are SQL2000 Enterprise SP3 w/ all updates running under
local acount SQLRunner
SQLRunner is a SQL sysadmin, it is a member of local Administrators and has
the same password on both servers.
There is no domain.

At first it looks like a windows-permission problem. However the OMWWIZD
share gets created fine which implies that the permissions are okay...

Does anybody have any idea, suggestion, wild guess etc???

million thanks

christos

Andrew J. Kelly

2005-03-30, 7:04 pm

I am not sure why the error but why not simply do a restore or an attach
manually? It's usually faster and cleaner than the wizard and you have
complete control of the situation. These may be of use to you:

http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scr...sp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server

http://www.support.microsoft.com/?id=274463 Copy DB Wizard issues

--
Andrew J. Kelly SQL MVP

"Christos Kritikos" < ChristosKritikos@dis
cussions.microsoft.com> wrote in
message news:6B991014-5168-4132-B387- E40AB8099EFC@microso
ft.com...
> Hello,
>
> I am using the Copy Database Wizard (CDW) to copy a database from one SQL
> server to another. Unfortunately I get the following error:
> Failed to copy file \\Servername\OMWWIZD
\SQL2000\MSSQL\Data\
dbname.MDF
>
> I went through KB 274463 and this sort of error is not mentioned. All the
> possible problematic steps mentioned in the article work fine:
> - the share (OMWWIZD) is created successfully
> - the database gets detached
> - all logins, DTS's etc get copied fine
> However the actual MDF file cannot be copied.
>
> My configuration is as follows
> Source: Win2000 Std Server w/ all updates
> Destination: Win2003 Std Server w/ all updates
> Both SQL servers are SQL2000 Enterprise SP3 w/ all updates running under
> local acount SQLRunner
> SQLRunner is a SQL sysadmin, it is a member of local Administrators and
> has
> the same password on both servers.
> There is no domain.
>
> At first it looks like a windows-permission problem. However the OMWWIZD
> share gets created fine which implies that the permissions are okay...
>
> Does anybody have any idea, suggestion, wild guess etc???
>
> million thanks
>
> christos
>
>

Sponsored Links