"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
>> >
>> >
>> >
>>
>>
>>

"Robert" wrote:

> 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
>
>