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.

link|improve this question

feedback

1 Answer

up vote 3 down vote accepted

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

link|improve this answer
1  
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! – CrabbyAdmin Jun 27 '11 at 15:42
Perfect, thank you kind sir! – CrabbyAdmin Jun 27 '11 at 16:31
show 1 more comment
feedback

Your Answer

 
or
required, but never shown

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