PowerShell script to backup site collections, write a log file and send a email for failures

Are you still using VB script to backup your site collection, come on dude…? It’s time to use the power of power shell...

There are lots of scripts published for backing up site collection, what special in mine??

Let me tell you what...

1) This script actually skip’s the failed site collection and report an email as well write in the log file.
2) The Log file will be written on either ways, whether the site got succeeded or failed.
3) One more final thing, I am using -Nositelock in my script. lol


#+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
# This script backups a list of site collection from a “text“ document and # writes to log file with URL in
# either case if it is succeeded or failed, it also sends a email on every # single backup failure with the
# Respective URL and exception
# Created by KannaGanesh May 10 2011
#++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

add-pssnapin microsoft.sharepoint.powershell
$date = (get-date).ToString()

# The below line reads the URL.txt file

$readfile = Import-Csv D:\URL.txt
$filepath

# The below four lines execute the backup and save in with URL Name (with Port # if available)

foreach ($line.URL in $readfile)
{$FilePath = “D:\backups\” + $line.Url.Replace("http://",””).Replace(“/”,”-“).Replace(":","-") + “.bak”;
backup-spsite -identity $line.URL -path $filepath -nositelock -force -errorVariable a -ea SilentlyContinue ;
$a

# The below if / else statement will write the log files and send a email for any failure

If ($a -ne $null)
{write-output "$date Backup failed for $line.URL with" $a | out-file D:\log.txt -append ;
$emailFrom = "from@example.com"
$emailTo = "emailed@example.com"
$subject = "Sitecollection Backup failed"
$body = "$line got failed, Please check the log files @ D:\log.txt for more details"

# Use commas for multiple addresses

$smtpServer = "Your SMTP Address"
$smtp = new-object Net.Mail.SmtpClient($smtpServer)
$smtp.Send($emailFrom, $emailTo, $subject, $body)}
else
{write-output "$date succcess $line" | out-file D: \log.txt -append}
}


Ensure the following
1) Before executing this script, ensure you eliminate any unwanted spaces or # signs
2) Ensure your URL.txt file is in below format.
URL
http://URL1
http://URL2
http://URL3
3) Make sure your script has access to Url.txt and log.txt files,
4) Hope you have a valid SMTP service which can sent emails when there is a failure

Disclaimer

We have tested this script in our environment and confirmed to be working fine, please execute the same in dev / test environment before moving in to production to avoid any damage

Wish you all the success.

Poweshell script to install and activate Feature in SharePoint 2010

People who say, Boss I am fed up typing this powershell / STSADM command to Install the features... can we make it easy somehow ???

Yes buddy, here you go... Copy the below script and your done!

################################################################################################################################################
# This Powershell script helps you to install and activate features for
# your webapplication / site collection
# If the feature already exist then this will deactivate, uninstall then
# Install and enable, based on your requirment
# Created By Kannaganesh, dated 03-May-11
#+++++++++++++++++++++++++++++++++++++++++++++++++++++++

# remove "#" in the below line, if you are not running this script in
# SharePoint Shell.This will install Powershll snap-ins for Sharepoint
# add-pssnapin microsoft.sharepoint.powershell

# Below line reads your keyboard input for feature folder name

$FolderName = read-host "FeatureFolderName"

# Below line reads ur keyboard input for URL

$URL = read-host "URL"

# Next two lines check for the availablity of the feature which you are about to install

$getfeature = Get-SPfeature | where-object {$_.DisplayName -eq "$foldername"}
$getfeature
If ($getfeature -eq $null)

# Below two lines installs the feature if it is not already installed.

{Install-SPFeature $folderName -force;
Enable-SPFeature $FolderName -url $URL;
write-output "$folderName is installed and enabled for $url" }

# If Yes the following else statment will disable, uninstall then Install # and enable the feature to your site

else

{disable-spfeature -identity $foldername -url $url ;
start-sleep -s 5 ;
uninstall-spfeature -identity $foldername;
start-sleep -s 5 ;
Install-SPFeature $folderName -force;
start-sleep -s 5 ;
Enable-SPFeature $FolderName -url $URL ;
write-output "$folderName is re-installed and enabled for $url"
}

Consideration

1) The feature folder is available on all the servers in your farm.
2) The feature your trying to install / activate is a farm based and not server based.
3) If it is server based, this needs to be executed on all servers in farm.

Procedure for executing this script

I am sure, most of you know, how to execute this script. For folks, who need assistance follow the below steps.

1) Copy the above script to a notepad and save it as Installfeature.ps1 (you can use your defined file name with ext .ps1). Ensure, you elimenate space or extra "#" in the copied script, if any.

2) Open SharePoint Shell as Administrator.

3) Navigate to the folder, where your script is placed.

4) Now its time to execute, .\installfeature.ps1 (this can be easily achieved by .\In and a tab).

5) You will be prompted for folder name and URl values one after other.

6) What next, if your feature is not existing. It silently installs and "tells you BOSS your done !"

7) If It is existing , then you will be prompted for your approval to continue / cancel.

Hope this helps...

Disclaimer :-

This script is tested in few env and found to be working, please try the same in your dev/test env before moving in to production.

Good luck :)