Solved

Database attach migration - different site collection?

Posted on 2011-02-18
2
683 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 25 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 225 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Last week I faced a strange issue recently, i have deployed SharePoint 2003 servers for one project and one of the requirements was to open SharePoint site from same server. when i was trying to open site from the same server i was getting authentic…
The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

705 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