none
Restore Sharepoint Site Collection to different site collection RRS feed

  • Question

  • Hi,

    We have started using SharePoint on-premise and looking at setting up a development site collection which mirrors our main site.

    I have created the different site collections our main and our development one. I have backed up the main site collection and I now want to restore this to our development site collection.

    I know I need to use the powershell command  Restore-SPSite and the commands with it. I just need to confirm that when I restore the backup to the development site collection, I will be restoring it to the database which I configured for the development site collection and not our main database.

    Anybody able to confirm this?

    Thursday, March 30, 2017 3:48 PM

Answers

  • You could use Restore-spsite with the -contentdatabase parameter https://technet.microsoft.com/nl-nl/library/ff607788.aspx
    • Proposed as answer by Anthony Kersten Thursday, March 30, 2017 5:24 PM
    • Marked as answer by Paddy182 Friday, March 31, 2017 7:33 AM
    Thursday, March 30, 2017 3:59 PM

All replies

  • You could use Restore-spsite with the -contentdatabase parameter https://technet.microsoft.com/nl-nl/library/ff607788.aspx
    • Proposed as answer by Anthony Kersten Thursday, March 30, 2017 5:24 PM
    • Marked as answer by Paddy182 Friday, March 31, 2017 7:33 AM
    Thursday, March 30, 2017 3:59 PM
  • Ok, will add that in, now next question I just thought of, when specifying the Database server will it support SQL instance name, i.e. -DatabaseServer SQLSERVER\SQLINSTANCE?
    Thursday, March 30, 2017 4:13 PM
  • You really should use SQL alias. I use this in all cases! Both SQL clusters and standalone SQL. Probably too late now but for the next time: https://blogs.msdn.microsoft.com/priyo/2013/09/13/sql-alias-for-sharepoint/ and yes I believe it will work with instance name.
    Thursday, March 30, 2017 4:33 PM
  • It's a new site development so if these changes are recommended I will make them.  Thanks for the help :D
    Friday, March 31, 2017 7:33 AM