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

I have a Windows Server 2008 R2 that had a unclean power down and now the whole install is broken. Before I struggle to resurrect the machine, I'd like to know if there is a way to take the installed files from the broken server and somehow move them to a new machine.

I have backups, but not of all the databases, so its pretty useless as I need them all.

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
    
Don't forget the LDF's. They're vital. –  Bob Oct 3 '12 at 19:37
    
It's in the parentheses –  joeqwerty Oct 3 '12 at 19:38
    
Sorry: "Don't forget" was for Samuel's benefit. I agree with your answer 100%. –  Bob Oct 4 '12 at 11:27

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.