Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I have a Windows Server 2008 R2 that was running SQL Server, until it had a unclean power down and now the operating system become corrupted. Before I struggle to resurrect the machine, I'd like to know if there is a way to move the SQL server installation to a new machine, without relying on backups.

share|improve this question

2 Answers 2

up vote 2 down vote accepted

You don't move the SQL Server install. (Or really, really shouldn't.)

You install SQL server fresh on a new machine and move the databases.

Here's a rather long step-by-step article form Microsoft on how to move all the "stuff" from one SQL Server install to a SQL Server install on another machine.

It's too long to post here, but the section headers are:

Step 1: How to move user databases

Step 2: How to transfer logins and passwords

Step 3: How to resolve orphaned users

Step 4: How to move jobs, alerts, and operators

Step 5: How to move DTS packages

Step 6: Change the sp_configure settings to match the previous computer

share|improve this answer

If you have access to the database files (mdf and ldf) then you can copy those to a new SQL Server and attach them.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.