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/features/mssql/article.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/columnists/cBunch/movingyouruserswiththeirdatabases.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/scripts/scriptdetails.asp?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/scripts/contributions/1598.asp     Script
Roles and Permissions


Show quoteHide quote

how do you edit query results in results pane of Management Studio
problem with SQL 2000 Enterprise Manager display
creating unique index and clustered index in sql server management studio
modifying stored procedure with SSMSE
Server Memory usage\Performance problem