HP Data Protector A.06.11 script solution for Microsoft Office SharePoint Server 2007 and SharePoint Server 2010 Technical white paper Table of contents Introduction ................................................................................................................................... 2 Installation and configuration .......................................................................................................... 3 Prerequisites .........................................................
Introduction Data Protector offers support for Microsoft Office SharePoint Server 2007and Microsoft SharePoint Server 2010 (from now on, both are called Microsoft SharePoint Server). This solution enables you to back up and restore Microsoft SharePoint Server data that is stored in Microsoft SQL Server databases. For example: The configuration database (SharePoint_Config) Content databases (SharePoint_AdminContent_Label, WSS_Content_Label,...
Installation and configuration Prerequisites If you plan to run ZDB and instant recovery (IR) sessions, ensure that the SPSearch and OSearch index files of each SSP / SSA reside on a disk array. Microsoft Office SharePoint Server 2007 The default location for the SPSearch index files is: C:\Program Files\Microsoft Office Servers\12.0\Data\Applications The default location for the OSearch index files is: C:\Program Files\Microsoft Office Servers\12.
The following are the installation instructions that apply to both, the Microsoft Office SharePoint Server 2007 and Microsoft SharePoint Server 2010 environments: 1. On the Microsoft SharePoint Server front-end Web server on which you plan to run the Data Protector PowerShell script, install Windows PowerShell, the Data Protector User Interface component, and copy the Data Protector PowerShell script moss_backup.ps1 to the Data_Protector_home/bin directory.
– Open the writerstab_info file at the location Data_Protector_home\Config\Server\Integ\Config\MSVSSW – The writerstab_info file needs to include two entries for the SharePoint 2010 writers -name "SPSearch4 VSS Writer" -guid {35500004-0201-0000-0000000000000000} -desc "SPSearch4 VSS Writer" -type 0 -name "OSearch14 VSS Writer" -guid {0ff1ce14-0201-0000-0000000000000000} -desc "OSearch14 VSS Writer" -type 0 (See Figure 2) – If these entries are not available, you need to replace the current writerstab_info f
Figure 2 Writerstab_info file content In Figure 2, the SharePoint 2010 writers are colored in blue. Configuring the integration For details on how to configure the Data Protector VSS integration, see the HP Data Protector integration guide for Microsoft applications and the HP Data Protector zero downtime backup integration guide.
http://technet.microsoft.com/en-us/library/cc262932.aspx#Section32 Otherwise, you will not be able to restore the database. How the script works When you run the Data Protector PowerShell script moss_backup.ps1, Data Protector first queries for information about the Microsoft SharePoint Server environment. Then it creates backup specifications (of the MS Volume Shadow Copy Writers type).
Figure 3 Selection Microsoft Office SharePoint Server 2007 databases For a system with the Windows SharePoint Services Help Search and Office SharePoint Server Search services enabled, the script creates a backup specification that has the SPSearch VSS Writer and OSearch VSS Writer objects selected (Figure 4).
Figure 4 Selecting Microsoft Office SharePoint Server 2007 search index files Microsoft SharePoint Server 2010 In a Microsoft SharePoint Server 2010 environment, the script creates a separate backup specification for each Microsoft SharePoint Server 2010 system that has at least one of the following services enabled: SharePoint Foundation Database SharePoint Foundation Help Search SharePoint Server Search For a system with the SharePoint Foundation Database service enabled, the script creates a backup spec
The script options enable you to split the process into two parts: first you create the backup specifications and then you start backup sessions. In this way, you can manually modify the newly-created backup specifications in the Data Protector GUI before the backup is actually started.
Specifies which Data Protector device to use for backup. You can specify only one device. Important If only one device is used to back up a multi-system farm, the corresponding backup sessions cannot run in parallel. This prolongs the time during which the farm is in read-only mode. Specifically, the farm is in read-only mode from the moment when the backup sessions are started up until all VSS snapshots are created.
-reduce Applicable only to Microsoft SharePoint Server 2010. If this option is specified, the script excludes mirrored query components from backup to reduce the backup size. -resumefarm To be used after restore. This option returns the farm to a working state by resuming all background activities and crawling, unlocking sites, and starting Microsoft SharePoint Server services. Important The script must be run from the Data_Protector_home\bin directory on the front-end Web Server system.
Figure 5 Displaying the Data Protector PowerShell script syntax Creating backup specifications (examples) 1. To create backup specifications in which the backup device filelib_writer1 is specified for use, run: moss_backup.
2. To create backup specifications with the label weekly in their names and in which the backup device dev1 is specified for use, run: moss_backup.ps1 –createonly –device dev1 –prefix weekly 3. To create backup specifications with the label weekly in their names and the backup device dev1 specified for use, and to automatically start the corresponding backup sessions, run: moss_backup.ps1 –device dev1 –prefix weekly 4.
List of hosts and their services -------------------------------virtual20 Application Server Windows SharePoint Services Help Search Windows SharePoint Services Database Information Management Policy Configuration Service Office SharePoint Server Search Shared Services Timer Office SharePoint Server Search Admin Web Service Excel Calculation Services Single Sign-on Service SSP Job Control Service Portal Service Office SharePoint Server Search Document Conversions Launcher Service Document Conversions Load B
SSP Job Control Service Portal Service Office SharePoint Server Search Windows SharePoint Services Web Application Windows SharePoint Services Administration Windows SharePoint Services Help Search Windows SharePoint Services Timer -------------------------------SQL hosts list virtual20 Index hosts list virtual20 VIRTUAL21 VIRTUAL23 Help search hosts list VIRTUAL21 VIRTUAL23 ------------------SUSPENDING FARM 02/10/2010 03:16:43 ------------------Farm SharePoint_Config Service Windows SharePoint Services Hel
-> Setting lock state to readonly Crawled by: , id Crawl status: -> Pausing background activity ... Quiesce status is: Quiesced ------------------SUSPENDING END 02/10/2010 03:18:28 -------------------> Starting backups...
Root title: Shared Services Administration: SSP1 -> Reverting lock for site http://virtual20:123/ssp/admin to none -> Resuming background activity ... ------------------RESUMING END 02/10/2010 03:19:18 ------------------=============================== MOSS backup script finished 02/10/2010 03:19:18 Running time 00:02:48.3336122 =============================== 2. To start backup sessions using the existing backup specifications whose names are without prefix, run: moss_backup.ps1 –backuponly 3.
Figure 6 Scheduling a backup session using the Windows scheduler In Run, type: Windows_PowerShell_home\powershell.exe moss_backup.ps1 [Options] For details on Options, see “The script syntax”. In Start in, type: Data_Protector_home\bin In Run as, type a Windows domain user account DOMAIN\UserName that is configured as described in “Configuring user accounts”. Restore To restore Microsoft SharePoint Server data: Stop Microsoft SharePoint Server services Restore the data. Return the farm to a working state.
In addition, stop the following Microsoft Office SharePoint Server 2007 / Microsoft SharePoint Server 2010 services: – Windows SharePoint Services Administration / SharePoint 2010 Administration – Windows SharePoint Services Search / SharePoint Foundation Search V4 – Windows SharePoint Services Timer / SharePoint 2010 Timer Put the Microsoft SQL Server instance offline if you plan to restore one of the following Microsoft SQL Server databases: – master – model – msdb – a database for which Microsoft SQL Ser
Restoring using the Data Protector GUI 1. In the Context List, click Restore. 2. In the Scoping Pane, expand MS Volume Shadow Copy Writers, expand the client whose data you want to restore, and then click MS Volume Shadow Copy Writers. 3. In the Source page, select the data that you want to restore.
Figure 8 Selecting Microsoft Office SharePoint Server 2007 Search index files for restore 4. In the Options page, specify the MS Volume Shadow Copy specific restore options. 5. In the Devices page, select devices to use for restore. 6. Click Restore, review your selection, and click Finish. Restoring using the Data Protector CLI You can restore Microsoft SharePoint Server data using the Data Protector omnir command.
Limitations The omnir command syntax should not contain more than 8191 characters. If you have so many –tree objects that the syntax exceeds 8191 characters, split the objects and run two separate sessions. After the restore After the restore: 1. Enable and start the service IIS Admin Service (only if the whole farm was restored) 2. Enable the service Office SharePoint Server Search / SharePoint Server Search 14. 3. Bring the Microsoft SQL Server instances online (if offline). 4.
An unexpected error has occurred. Action 1. Restart Microsoft SharePoint Server services on all clients in the farm. 2. Open the Internet Information Services (IIS) Manager and restart all application pools. In case an application pool fails to be restarted with the following error: Cannot Restore Application Pool. There was an error while performing this operation. wait for a few seconds and then restart the operation. 3. Delete browsing history in your web browser. 4.
For more information Visit the following Data Protector online resources to get more information: www.hp.com/go/dataprotector www.hp.com/go/imhub/dataprotector © Copyright 2010 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice. The only warranties for HP products and services are set forth in the express warranty statements accompanying such products and services. Nothing herein should be construed as constituting an additional warranty.