Re: Copy Database Wizard Fails to Copy Files

• Previous message: Allan Mitchell: "Re: Parameters problem"
• In reply to: Robert: "Re: Copy Database Wizard Fails to Copy Files"
• Messages sorted by: [ date ] [ thread ]

Date: Wed, 1 Dec 2004 16:12:33 -0500

Probably is permissions. Although this KB is titled around a scheduled job
it does a pretty good job of outlining how the permissions work:

http://www.support.microsoft.com/?id=269074

And make sure you can copy a regular file from the share on Server A to the
Share on Server B when you are logged in with the proper account.

-- 
Andrew J. Kelly  SQL MVP
"Robert" <Robert@discussions.microsoft.com> wrote in message 
news:55C835AD-DE92-4CC6-97D7-6490AF6C73AD@microsoft.com...
> Thanks for you reply, Andrew...I have seen your suggestions of articles 
> before.
>
> However, I am interested in getting DTS to work.  Such a simple example
> should not be so difficult.  Since its the actual tranfer of the files 
> that
> fails, I am wondering if its a permissions problem?  What account is used 
> to
> create the share, attach to the share from the destination, copy the 
> files,
> etc?  SQLServerAgent?
>
> Regards,
>
> Robert
>
>
> "Andrew J. Kelly" wrote:
>
>> Maybe this has the answer:   http://www.support.microsoft.com/?id=274463
>> Copy DB Wizard issues
>>
>> You may want to consider not using the wizard if you want to copy the 
>> entire
>> DB.  There are easier and in my opinion better ways:
>>
>> 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
>>
>>
>>
>> -- 
>> Andrew J. Kelly  SQL MVP
>>
>>
>> "Robert" <Robert@discussions.microsoft.com> wrote in message
>> news:670DD672-0098-41F3-93DA-492AC1101316@microsoft.com...
>> > Running SQL Server 2000 SP3a on Win2000 Server (fully patched).
>> >
>> > Trying to get a simple example to work for copying a Test DB (which has
>> > one
>> > simple table) on ServerA to ServerB.  DB does not exist on ServerB, 
>> > both
>> > Servers running as services with identical accounts (made 
>> > administrators;
>> > not
>> > Local System).
>> >
>> > Everything works fine in the DTS (using default options):
>> > Logins........Ok,
>> > Master.......Ok,
>> > MSDB.......Ok,
>> > Errors......Ok,
>> > <<CDW Database Tasks Fails...detailed steps below:>>
>> > Successfully created the share OMWWIZC........Ok
>> > Begin to copy the database Test...................Ok
>> > Database Test has no active connections.......Ok
>> > Put the database Test in single user mode.......Ok
>> > Try to detach the database Test..............Ok
>> > Successfully detached the database Test......Ok
>> > Failed to copy file \\ServerA\OMWWIZC\Program Files\Microsoft SQL
>> > Server\MSSQL\data\Test_Data.mdf.........Failed
>> > Successfully attached the database Test on source.......Ok
>> > Successfully deleted the share OMWWIZC.........Ok
>> > <<End of CDW trace>>
>> >
>> > Cannot get anything to transfer either from ServerA to ServerB or
>> > vice-versa.  Constantly getting the same error  (Failed to copy 
>> > file.....)
>> >
>> > Help!?!
>> >
>> > Regards,
>> >
>> > Robert
>> >
>> >
>> >
>>
>>
>> 

• Previous message: Allan Mitchell: "Re: Parameters problem"
• In reply to: Robert: "Re: Copy Database Wizard Fails to Copy Files"
• Messages sorted by: [ date ] [ thread ]