Copy database

What is the best way to copy an entire SQL Server 2K DB? I want to take an
existing DB on one computer, and move its entirety to another. It seems
that DTS will only import/export tables... I'd like to be able to get the
whole enchilata, schema, tables, etc.
Best way is either do backup and restore or attach it.
http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://www.databasejournal.com/featu...le.php/3379901 Moving
system DB's
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://www.support.microsoft.com/?id=221465 Using WITH MOVE in a Restore
http://www.sqlservercentral.com/colu...rdatabases.asp
Moving Users
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
http://www.support.microsoft.com/?id=320125 Moving a Diagram
http://www.support.microsoft.com/?id=274463 Copy DB Wizard issues 2000
http://www.sqlservercentral.com/scri...tions/1598.asp Script
Roles and Permissions
Andrew J. Kelly SQL MVP
"William F. O'Neill" <wfoneill001@.bellsouth.net> wrote in message
news:enSR%23%236FGHA.1088@.tk2msftngp13.phx.gbl...
> What is the best way to copy an entire SQL Server 2K DB? I want to take
> an existing DB on one computer, and move its entirety to another. It
> seems that DTS will only import/export tables... I'd like to be able to
> get the whole enchilata, schema, tables, etc.
>