Error running Copy Database Wizard (CDW)

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


.

Relevant Pages

  • RE: Backups have Shadow Copy Problems
    ... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ...
    (microsoft.public.windows.server.sbs)
  • Re: upsizing to sql 2005
    ... the word SERVER in it, ... You can access to the database by multiple means (Access, ... and how does it update the SQL database with the new records in Access? ... Query Name: Arcadia - ARC ...
    (microsoft.public.access.queries)
  • Re: Linked Tables in Access
    ... any use of SQL Passthru, Linked Tables or any other use of MDB / MDE ... server, or would I also need to convert *those* queries to passthrough ... I've been trying to understand why Access database files become corrupt. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Trouble Getting VS.Net 2003 WalkThroughs MSDE Connection
    ... Config Tool of SQL Server? ... > link to download the PUBs database. ... >>> Setup and they directed me to install MSDE and they attached a ...
    (microsoft.public.sqlserver.msde)
  • Re: Leveling by ID vs. "Standard"
    ... of this trade called Project Management. ... a database for the "Project Tables," ... to write reports on data from the server database. ... product supporting queries created with SQL. ...
    (microsoft.public.project)
Loading