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.

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

1 Answer 1

up vote 3 down vote accepted

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

share|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! –  Windows Ninja Jun 27 '11 at 15:42
    
    
Perfect, thank you kind sir! –  Windows Ninja Jun 27 '11 at 16:31

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.