Can someone point me in the right direction to figure out
what's wrong here?

I'm trying to copy a very simple DB between two servers
using the SQL 2000 Enterprise Manager DB Copy Wizard. All
steps looks good up to detaching the source DB, but then
the actual copy of the share database mdf file to the
destination server fails. The Error Code in the Task
Detail box is 'failed'. The Error Code in the Step Detail
box is '-2147467259'.

The Package Log Error Description is:

Step Error Source: Microsoft Data Transformation Services
(DTS) Package
Step Error Description:Unspecified error

Step Error code: 80004005
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:1100

This should address the error:

http://www.support.microsoft.com/?id=274463 Copy DB
Wizard issues



Personally I prefer to use a Restore of a FULL backup or just issue a
detach and attach. These have more info:

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


"Tech - SBT" <bglynn (AT) sbtontheweb (DOT) com> wrote

No, that didn't address it, I had already gone through it.

I am changing drive letters from one server to the other - will restore and
backup address that change?

Will I need to do anything more regarding users, etc. or will everything
work?

Thanks


"Andrew J. Kelly" <sqlmvpnooospam (AT) shadhawk (DOT) com> wrote

If your placing the files in a different path or drive than they originated
you must use the WITH MOVE option of RESTORE. If you use sp_attach_db then
you can specify the physical locations there as well.

--

Andrew J. Kelly
SQL Server MVP


"Tech - SBT" <bglynn (AT) sbtontheweb (DOT) com> wrote