We needed to replace our Motherboard on a server running win 2K Adv.
Server with SQL server 2000. After replacing, we could not bring
the system back with the previous OS. So, we have decided to
migrate to Windows 2003 server and install SQL svr on it.

On the old server, the SQL DB is residing on a seperate disk.
Is there any way one can install SQL on the new server and import
the data from the disk. Many posts talk about how to do detach/attach etc.
The case there is they have a running source server. In my case, I don't.

any pointers will be appreciated

Regards,
Anand

Once you load the new OS you have to install SQL Server as well. Then you
can use one of several methods to get the databases back on line. See these
for more details:


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


"Anand" <anandns (AT) hotmail (DOT) com> wrote