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

SharePoint 2010 automatically installed the database on SQL Server Express 2008 but I need to migrate the database to SQL Server 2008. How can I go about doing this?

This is installed on Windows Server 2008 R2 Standard.

share|improve this question
up vote 3 down vote accepted

Backup and restore or detach and re-attach are the two easiest methods.

share|improve this answer
Short and concise, just the way we like it! – 3molo Jun 27 '11 at 14:05
Details are available if needed. ;) – joeqwerty Jun 27 '11 at 14:09
Would you mind linking to or providing the steps for one of these (either is fine)? I appreciate it joe...amazing how many answers you have! – Windows Ninja Jun 27 '11 at 15:42
Perfect, thank you kind sir! – Windows Ninja Jun 27 '11 at 16:31

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.