I just migrated my SBS2008 network to SBS2011. Everything went great, now I need to move the sharepoint over.
I am not a SQL or Sharepoint expert.
I have been looking for a step by step list, but cannot find one, that shows all the steps, they all say backup then restore and upgrade. I know I need to do a Database backup then restore, according to TechNet.
Problem is, I’m not sure how to create the SQL instance to restore it to.
Can someone give me step by step instructions on how to upload and then upgrade my *.bak file to 2011 sharepoint using 2008 sql?
Also after everything is moved:
1. How do I detach the DB from sql 2005? When I go to detach it says the db is in use. Is there a service to stop? I stopped the SQL server service for sbsmonitoring, but it still wouldn’t detach. ( I will detach before I upload to new server so data isn’t changed on old system)
2. Once the DB is uploaded and upgraded in sql 2008, will the same port 4721 work?
Thank you for your help