Solved

Database attach migration - different site collection?

Posted on 2011-02-18
2
652 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
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

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Pimping Sharepoint 2007 without Server-Side Code Part 1 One of my biggest frustrations with Sharepoint 2007 in the corporate world is that while good-intentioned managers lock down the more interesting capabilities of Sharepoint programming in…
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…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

757 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now