?
Solved

Database attach migration - different site collection?

Posted on 2011-02-18
2
Medium Priority
?
687 Views
Last Modified: 2012-05-11
I have a 2007 SP server with several site collections with dedicated databases. Can I make an existing non-root site collection into a root site collection on a new SP 2010 server? Is there a special procedure or just regular database attach will work?
0
Comment
Question by:MisUszatek
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 5

Assisted Solution

by:navdeepmadan
navdeepmadan earned 100 total points
ID: 34931675
No you can't upgrade a non-root site collection to root site collection. Database attach is best method to upgrade to sharepoint 2010.
0
 
LVL 4

Accepted Solution

by:
Dangeriz earned 900 total points
ID: 34940031
You can't upgrade a non-root site collection to a root site collection. The database migration method will copy the exact relative paths of the site collections.

But what you can do is:
- Do the normal database attach upgrade (this will upgrade your 2007 databases to 2010).
- Backup the non-root site collection that you want to become the root site collection by using the stsadm -o backup command:
example: stsadm -o backup -url http://portal/sites/sitecollection1 -filename c:\sc1backup.bak
- Restore the non-root site collection to the root site collection URL by using the stsadm -o restore command:
example: stsadm -o restore -url http://portal -filename c:\sc1backup.bak

*Note* Before you start, make sure you don't already have a root site collection for the web app or else your restore won't succeed (unless you want to overwrite the existing root site collection, then you can use the -overwrite switch in the restore command).

*Note* You will have 2 site collections with the same information, so you can just delete the non-root site collection after the successful restore.

The trickiest part in all this is that it's almost guaranteed that you will have an existing root site collection for the web app. And you can only have 1 root site collection, so use Central Admninistration (View All Site Collections) to have insight over your site collections and decide which site collection you want to be your root site collection. If the you want to move your existing root site collection to a non-root site collection first, then you can use the same backup/restore method to move that site collection.
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you create your solutions on SharePoint sooner or later you will come upon a request to set  permissions of the item depending on some of the item's meta-data - the author, people assigned as approvers, divisions, categories etc. The most natu…
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question