SharePoint 2010 Powershell script to restore a Site Collection from a Backup.

SharePoint 2010 Powershell script to restore a Site Collection Backup

Here is my script I wrote to do a restore from a Site Collection Backup.
This will create a new content database for the site collection.  It made sense for us to do this because each site collection was a military unit that could be redeployed and they might want to take the database with them.

Since I was re-running my script, (and timing the job) I started out by deleting the site collection. 
Unless you're doing the same, you will not need this:

Get-SPContentDatabase -Identity "WSS_Content_SiteCollection1" | Remove-SPContentDatabase -Confirm:$false

Note: That's all one line ^

New-SPContentDatabase -Name "WSS_Content_SiteCollection1" -WebApplication http://sharepoint.name

Note: That's also all one line ^
Wait, did I just delete a site collection only to add it back???  Yes I did.  As I was running the restore job multiple times I wanted to be sure the previous attempt was gone.  Using this method will ensure that. Using the GUI (Central Admin) to delete a site collection is not recommended.  You'll find you won't be able to add it a second time because the old references don't get removed and the site collection is still in a site collection recycle bin.  If you remove it from the recycle bin that still might not help.

This displays no output, so I added some to tell me the time this started and when it finished. The rest of the script script is below.

$StartDate = Get-Date; "Restoring SiteCollection1"
Restore-SPSite -Identity http://sharepoint.name/sitecollection1 -Path \\UNCPATH\to\save\location\sitecollection1.bak -force -databasename "WSS_Content_SiteCollection1" -Confirm:$false
$EndDate = Get-Date; "SiteCollection1: Started at $StartDate and Completed at $EndDate"

The optional -force command will allow overwrite.  Since I know my content database is blank I don't need it, but an old guy named Ben told me to, so I used it anyway. 

The optional database name is a good idea as that tells the script exactly where you want to restore that site collection. Don't trust the GUI for this one either.  I've had a site collection restore to the wrong database when Central Admin told me that only the right database was "on" and the rest were marked as "off" in CA.

 

Comments

Post a Comment

Popular posts from this blog

Setting SharePoint announcements to auto delete after expiration

Image
Setting announcements to auto delete after expiration One thing that always bugged me was the expiration date attached to an Announcement list that does nothing out of the box. Sure, you could always add a filter and change the default view but as soon as you add an Announcements web part to a page the view is UNFILTERED even if a filtered view is the only one to choose from.  You or I could change the default view, but we can’t trust all users to do so. A workflow would be fine to delete the item – simply pause until the expire date then delete the current item.  The workflow would stick with the template if you saved your list off as a template and then still work when you created a new list from that template.  That’s good, but still relies on the user creating the right Announcement list. The better answer was to change the Announcements default content type.  If anyone asks, tell them it’s called Governance, Sparky. The first step was to go to site sett...
Read more

Updating a single field in a SharePoint List using Power Automate Flows

Image
  Updating a single field in a SharePoint List using Power Automate Flows Updating a single field in a SharePoint List using Microsoft Flows (aka Microsoft Power Automate) can be a bit tricky with longer lists with lots of required fields and drop downs possibly resetting your data. The work around is code, but if there are non-developers creating flows, then this process is even more cumbersome. As a result, the Flow below will do the heavy lifting using a separate list and then anyone can populate that list from a different Flow when such a thing is needed. First step: create the list Here’s the input needed in this list. List: The name of the list SiteLink: The link to the site (trim off /lists/xyzlist) IDFromSource: This is the internal ID of the item to update FieldToUpdate: The name of the field you want to update. This is case sensitive. ValueForField: What you want to set it to. Next, create the Flow. Here’s what it will look like   When a Shar...
Read more

SharePoint driven rich text dashboard using jqueryui. (JQuery file)

Jquery file for Operations Dashboard Download this file <script type="text/javascript"> $(document).ready (       function()       {             SP.SOD.executeFunc('sp.js', 'SP.CamlQuery', RetrieveListValues);       } ); function RetrieveListValues() {       var query = new SP.CamlQuery(); query.set_viewXml("<View><Query><OrderBy><FieldRef Name=\"SortOrder\"/></OrderBy></Query></View>");                                     var clientContext = new SP.ClientContext("https://sharepoint.name/section/OD");       var oList = clientContext.get_web().get_lists().ge...
Read more