1

I have a Site Collection Content DB back up. I want to create/ restore to existing site collection. Are there any ways to do that?

  • 1
    Do u want overwrite the existing site collection? – Waqas Sarwar MVP Feb 8 '18 at 11:57
  • Yes @WaqasSarwarMVP – Sivakumar Piratheeban Feb 8 '18 at 13:53
  • 1
    Lukas already respond it, if that does not meet your requirement then could you please add more detail in your question, where is the database, how much sites in the db, do you have test farm? what version of sharepoint? – Waqas Sarwar MVP Feb 8 '18 at 14:10
2

We can only Attach an existing content database to a web application, while cannot attach an existing content database to a site collection.

To attach an existing content database to a web application:

1.Restore a backup copy of the database in SQL.

2.Use the following PowerShell to attach an existing content database to a web application:

Mount-SPContentDatabase "<ContentDb>" -DatabaseServer "<DbServer>" -WebApplication http://SiteName

Refer to the article about Attach or detach content databases in SharePoint 2013:

https://technet.microsoft.com/en-us/library/ff628582.aspx

| improve this answer | |
3

You did not specify which version of SharePoint you have. But if it is at least 2010, unattached content database can be used.

See https://technet.microsoft.com/cs-cz/library/hh269601(v=office.14).aspx

  1. Restore the database to SQL server
  2. Use PowerShell or UI to restore the site collection you need
| improve this answer | |
  • Mount-SPContentDatabase command to mount DB with Web app. But can be used to restore the site collection as well. – Sivakumar Piratheeban Feb 9 '18 at 9:21
  • 1
    Yes, but if you want to restore site collection that already exist in the farm (e.g. you want fo back in time) you won’t be able to mount the database. – Lukas Nespor Feb 9 '18 at 9:25

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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