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.
asked Jun 27, 2011 at 13:40
Add a comment |
1 Answer
Backup and restore or detach and re-attach are the two easiest methods.
answered Jun 27, 2011 at 14:04
- 1Short and concise, just the way we like it!3molo– 3molo2011-06-27 14:05:40 +00:00Commented Jun 27, 2011 at 14:05
- Details are available if needed. ;)joeqwerty– joeqwerty2011-06-27 14:09:40 +00:00Commented Jun 27, 2011 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– Windows Ninja2011-06-27 15:42:06 +00:00Commented Jun 27, 2011 at 15:42
- msdn.microsoft.com/en-us/library/ms187858.aspx + msdn.microsoft.com/en-us/library/ms187048.aspxjoeqwerty– joeqwerty2011-06-27 16:22:00 +00:00Commented Jun 27, 2011 at 16:22
-