Solved

Database attach migration - different site collection?

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SharePoint 2013 - User  keeps dropping 7 46
Sharepoint Cascading Links 11 70
Error while setting up the Server Farm Account 8 40
Sharepoint KB 2 73
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…
SharePoint Designer 2010 has tools and commands to do everything that can be done with web parts in the browser, and then some – except uploading a web part straight into a page that is edited in SPD. So, can it be done? Scenario For a recent pr…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

816 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

12 Experts available now in Live!

Get 1:1 Help Now