Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I need to restore my database to SQL server 2008. Currently we are having our database in SQL Server 2005 in one server. We need to take the back up of that database and move that database to SQL server 2008 in another server. I can find the steps to move 2008 to 2008 or 2008 to 2005. But I can't find any documents or guidelines to move 2005 to 2008.

How can I do this?

share|improve this question

From your question, it seems like you want to restore a SQL 2005 Database on a SQL 2008 Server. all you should have to do is backup the Database on SQL 2005, move the backup file, and restore on SQL 2008. However It is not supported to restore from SQL 2008 in SQL 2005

share|improve this answer

It is not different to restoring 2008 DB to SQL Server 2008.

Fresh tutorial for you )))

share|improve this answer

Your Answer


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.