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

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/scri...p?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 (AT) discussions (DOT) microsoft.com> wrote

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:

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 (AT) discussions (DOT) microsoft.com> wrote

I had the exact same problem until I executed the package under an account
that was explicitly defined in the sysadmin role, and not inheriting it.

Regards,

Don

"Robert" wrote:

The another reason can be there is no room on disk OMWWIZf share is created on.
I have just discovered it. Regards.

"Don" wrote: