Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I have a site backup and i want to create two site collection from that backup in one web application.when i try to restore second site collection on same web application it restrict me to do so.As site backup is of size 2 gb hence i even can not save it as template.this is a publishing site.

When i Tried to Restore-SPSite i get the error. "The operation that you are attempting to perform cannot be completed successfully.No Content database in the web application were available to store your sitecollection" The existing content database may have reached maximum no of sitecollection or be set to read only or be offline or may contain a copy of sitecollection."

In My case Content DB allready containing a copy of site collection

Please help me.

share|improve this question
1  
Thanks for your reply. i already have tried Backup-SPSite and Restore-SPSite and export/import, But this does not full fill my requirement. –  Mitul Rana Oct 24 '12 at 6:14
add comment

2 Answers 2

Reason for restore failure:
You need to understand the fact that whenever you try to restore a site collection backup to the same content database from which the site backup was taken , there will be a GUID conflict. GUID for a site collection is unique and it gets stored along with the site collection backup.

Your content database has a table called dbo.sites with a column named "id" Refer to the screenshot below

enter image description here

This id should always remain unique for site collections inside a single content database.Your restore will fail as long as this guid is not changed.

Suggested Workaround
Save the site as a template through command line or powershell. Go to Central Admin and create a new site collection without selecting any template (select choose a template later option) during creation. Restore the site template with overwriting this new site collection.

Refer to this link below :- http://social.technet.microsoft.com/Forums/en/sharepointcollaboration/thread/b14e572a-ea17-47b4-93fe-4694451efe35

This workaround assumes that your site collection size isnt really that big and the custom solutions (wsps) are in a deployed/activated state at the web application level.

share|improve this answer
add comment

You can use PowerShell to achieve this with these commands: Backup-SPSite and Restore-SPSite. Here's a useful link with instructions on how to do this: http://ranaictiu-technicalblog.blogspot.com.ar/2010/06/sharepoint-2010-backuprestore-with.html

share|improve this answer
    
I think it will be an export/import, not a backup/restore that is required technet.microsoft.com/en-us/library/ee428301.aspx since restoring from a backup will prevent it from being restored since it will refrence the same GUIDs for the site –  pigeon Oct 24 '12 at 4:56
    
export/import is also taking too long to and finally fails without error. –  Mitul Rana Oct 24 '12 at 6:39
    
Backup Restore is no option. This is simple not allowed/supported thats way it is "so hard". –  Marco Scheel Jan 29 '13 at 16:08
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.