Sharepoint

Version as of 06:18, 21 May 2024

to this version.

Return to Version archive.

View current version

MS SQL


Microsoft Sharepoint Server Backup

When Zmanda Client for Windows is configured and licensed for Microsoft Shartepoint backup, it uses the Microsoft Volume Shadow Services to back up the Sharepoint database(s) and logs. ZWC uses either Sharepoint VSS Writer or MSDE Writer or both, depending how the Sharepoint server is configured for database backup.

Requirements for Sharepoint Server Backup and Restore

These instructions assume you have already installed and licensed the Amanda Enterprise server and the Sharepoint Server being backed up. There are a number of additional requirements:

  • The Volume Shadow Copy Service must be enabled. Although the Volume Shadow Service is enabled by default, it may have been turned off after Windows installation. To ensure that it is running:
  1. Right-click the My Computer icon and choose Manage from the popup menu.
  2. Expand the Services and Applications tree and locate the Volume Shadow Copy Service.
  3. If it is not started, do so.
  4. If necessary, change the General Properties to make the Startup Type Automatic rather than Manual.

Configuring Microsoft Sharepoint Backups from the ZMC Backup What Page

Create a dedicated backup set for each Microsoft SQL Server you intend to back up. On the Backup What page you are prompted to select what type of object you want to back up. Choose mssql, and the following options are displayed:

[need screen shot]

Host Name
The name of the machine running the Sharepoint server you intend to back up.
Compression
Check the box to compress backup images before transfer to the Amanda backup server.

After you have set the options, click the Add button to add the Sharepoint Server to the backup set. Click Apply to Server to commit the changes; you can then configure the backup set just as you would any other by setting the options on Backup Where, Backup How, and Backup When, etc.

Configuring Microsoft SQL Server Restores from the ZMC Restore What Page

Make sure that MS SQL is installed in the same location as when the backup was run. The databases and logs file locations should also match the original configuration. When you have selected the disk list entry that includes the MS SQL databases for restore, the Restore What page displays the following options: 

[need screen shot]

Select all the host databases and log files on the Restore->What page. The Zmanda Windows Client will automatically stop the Sharepoint Server and all dependent services as a pre-restore procedure. Although the Sharepoint service is automatically restarted by the Zmanda client after the restore, dependent services are not restarted.  To see what dependent services may need to be restarted after a restore, click Start, then right-click on My Computer and select Manage... from the pop-up menu. Click Services, then double-click Sharepoint from the list of services to display its properties.  The Dependencies tab will display any Sharepoint-dependent services that you should restart.

Troubleshooting

[need troubleshooting steps]

Troubleshooting Restores

  • If the SQL databases do not mount, refer to Microsoft documentation.