What is the best and safest way to copy about 55 Databases around 60 GB from
a server
running win2k to a new server running Win Server 2003 Ent. Ed. What are
the different options do i have? Can I copy all the current Db plans, jobs,
and Logins? What is a good practice for doing this? The win2k server is in
production right now. Do i have to shut it down?

Please Help. Thanks

These should help:


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

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

--
Andrew J. Kelly SQL MVP


"Shash Goyal" <Shash703 (AT) gmail (DOT) com> wrote