troubleshooting Question

Migrate sharepoint 2007 to 2010 from sbs2008 to sbs2011

Avatar of Kacey Fern
Kacey FernFlag for United States of America asked on
Microsoft SharePointMicrosoft SQL Server 2008
4 Comments1 Solution363 ViewsLast Modified:
Greetings experts,

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
IT Architect
Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros