469,364 Members | 2,398 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,364 developers. It's quick & easy.

Server Crashed/Need to move SQL 2000 DB

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
Jul 20 '05 #1
1 1843
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" <an*****@hotmail.com> wrote in message
news:b0**************************@posting.google.c om...
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

Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

10 posts views Thread by MVChauhan | last post: by
2 posts views Thread by Neil | last post: by
1 post views Thread by kb0odu.tj | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.