Backup a service application using PowerShell
If you are making changes to a service application and need to take a backup beforehand this can be done quickly using the Backup-SPFarm cmdlet. Here is an example of how to backup the Managed Metadata service application and proxy:…
SharePoint 2013 backup fails – Object Crawl-0 (E: on WW-SP) failed in event OnBackupComplete
Today I encountered the following failure message when running a manual backup of my SharePoint 2013 environment using Central Administration: Object Crawl-0 (E: on WW-SP) failed in event OnBackupComplete. For more information, see the spbackup.log or sprestore.log file located in…
PowerShell script to export all sites in a site collection to a seperate file
I have a requirement to export all sites with in site collection to a separate backup file. With lots of sub-sites I thought the best way to do this would be with a PowerShell script that utilises the Export-SPWeb command. …
Backup-SPFarm error – The backup job failed
In response to a user query on www.windows2008forums.co.uk I have managed to replicate the error generated while using the Backup-SPFarm command to backup an entire farm. Backup-SPFarm -BackupMethod Full -Directory D:\Backups\ The After trawling through the spbackup.log file I found…
Creating a SQL Maintenance Plan to backup SharePoint content databases
In addition to regular SharePoint backups I have decided to create a SQL Maintenance Plan to backup the content database to a file each night. This will enable me to quickly and easily restore the database directly in SQL should I need to,…
Example SQL query to backup a database to disk
This sample SQL query can be executed to backup a site collection database to a file, where WSS_Content_Intranet is the name of the database used by the Site Collection. Use WSS_Content_Intranet DBCC Shrinnkfile (‘WSS_Content_Intranet’) DBCC Shrinnkfile (‘WSS_Content_Intranet_log’) Go Backup Database WSS_Content_Intranet To Disk…
Automating SharePoint backup using Windows PowerShell
I have just started using the following PowerShell script to backup an entire farm to disk every night, the script is called by the Windows Task Scheduler (running the task as the Farm Administrator account). Add-PSSnapin Microsoft.SharePoint.PowerShell Backup-SPFarm -Directory \\WW-Backup\SharePointBackup…
Modify the number of backup threads
By default SharePoint is configured to use 3 backup threads. This can be increased to improve performance and reduce the amount of time taken to backup large farms. However, the log files can become more difficult to read. These are…