Re: Error running Copy Database Wizard (CDW)

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/scripts/scriptdetails.asp?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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:6B991014-5168-4132-B387-E40AB8099EFC@xxxxxxxxxxxxxxxx
> 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: Move System and User database
    ... Andrew, Thanks for your reply! ... will the sa password be moved to the new server if system database ... > Issues When a Database Is Moved Between SQL Servers ...
    (microsoft.public.sqlserver.server)
  • Re: tried dts copy of tables stored procedures etc and it fails exery time
    ... all its objects I would just either restore a full backup or use ... Issues When a Database Is Moved Between SQL Servers ... >, i don't have much expierience with sql 7 data base minuplation, can ...
    (microsoft.public.sqlserver.security)
  • Re: Error 15022: The specified user name is already aliased.
    ... The number of orphaned users fixed by updating users was 0. ... Is it because the ID is already aliased in the database? ... > Issues When a Database Is Moved Between SQL Servers ...
    (microsoft.public.sqlserver.security)
  • Re: Setting up Test of database using backup/restore
    ... Thanks Andrew...I have seen the references in your other posts but I just ... will the two be in production at one time, ... > I would go for the restore of the latest FULL backups as the least ... > Issues When a Database Is Moved Between SQL Servers ...
    (microsoft.public.sqlserver.server)
  • Re: How to cpy logins from one Server to another
    ... > to a New Location with Detach/Attach ... > Passwords Between SQL Servers ... > Issues When a Database Is Moved Between SQL Servers ...
    (microsoft.public.sqlserver.security)