I need to move Sharepoint from the Express edition of SQL Server to a full 2008 R2 edition.
I believe I can use the backup/restore functionality to do this but need more in-detail instructions!
Several questions arise:
1. How much needs moving; there are more than 1 databases under the main SHAREPOINT heading?
2. The two editions of SQL server are running on the same virtual windows server (2011SBS) so how do I handle the section that tells users how to access Sharepoint as a simple backup/restore will have duplicate instances?
3. How do I take the express instance offline?
I have little (no) SQL Server experience so need a simple guide to do this please !
Thanks in advance.