Attix5 Pro FAQ
Search:     Advanced search

Configuring Attix5 Pro to back up SharePoint 2010

Article ID: 103
Last updated: 04 Jan, 2013

Note: The SharePoint plug-in is not supported in V7. For documentation detailing how to back up SharePoint in V7, visit the Partner Area.

Pre-installation steps

  1. Create a user to run the Attix5 Pro backup service, e.g. "A5BackupUser".
  2. Give the user the Site Collection Administrator role in SharePoint for each site to be backed up (including Central Services if desired).

In the following example, Central Services is shown on the left, with a default site shown on the right. To add a Site Collection Administrator, go to Site Settings.

Shared Serv1.png        

Site1.jpg

Navigate to Site Collection Administrators.

Shared Serv2.jpg         Site2.jpg

Enter the Attix5 Pro backup service username and click OK.

Shared Serv3.jpg         Site3.jpg

 Using SQL Management Studio, give the user the "db_owner" role to the SharePoint Config database, the SharePoint Admin Content database and WSS Content databases. These can be found in the Users table under Security.

SharePoint Config database:

Sharepoint Config User.jpg

SharePoint Admin Content database:

SharedServices content user.jpg

WSS Content database:

WSS Content User.jpg

 Add the Attix5 Pro backup service user to each database and ensure that db_owner is enabled as pictured.

DB owner.jpg

In the registry, grant the user read access to LocalMachine\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\14.0\. Without this permission, errors will occur.

registry.jpg

Installation

  1. Install Attix5 Pro, specifying the backup service user.
  2. Run the Plug-in Installer and ensure that SharePoint is selected to install the SharePoint plug-in.
  3. Grant the user full control of the Backup Client SE directory. (Failure to do this results in a number of user interface errors, and you will not be able to back up).

Backup Client SE properties.jpg

The user also needs full control of the SharePoint dump directory, but this permission will be inherited for the default path if Full Control is specified for the Attix5 Pro directory.

The SQL service needs full control of the SharePoint dump folder (the user for this is “NETWORK SERVICE” by default).

Sharepoint folder properties.png

Post installation

Typically, the installation should display something similar to this:

Note: The details populated into the plug-in are taken from the registry key at LocalMachine\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\14.0\Secure\ConfigDB\dsn.

 SharePoint should appear in the Backup Selection tab.

Backup selection.jpg

Browse through the available nodes and select the items that you want to back up as you would select files and folders in the default Backup Selection tab. After making your selection, click the Backup toolbar button to initiate the first backup.

Note on Windows SharePoint Services using “Windows Internal Database”

If you are using SharePoint Foundation 2010, the SQL database will be SQL Server Embedded Edition (SSEE), which will appear in the services list as "Windows Internal Database (MICROSOFT##SSEE)". This version of SQL database is only accessible from the local machine, and is not intended for use as a standalone SQL server. As with other SQL versions, permissions need to be set if using the SSEE.

To connect to SSEE:

  1. Make sure that "Named Pipes" are enabled for the instance in SQL Server Configuration Manager
  2. Run SQL Management Studio on the local machine
  3. Use the following as the instance name: \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query

The permissions to be set remain the same as above.

Article ID: 103
Last updated: 04 Jan, 2013
Revision: 2
Views: 5144
Comments: 0
Posted: 08 Feb, 2012 by Flood A.
Updated: 04 Jan, 2013 by -- .
This article was:  
Prev   Next
Article 101 - Configuring Attix5 Pro to back up SharePoint 2003     Article 79 - V6.2.x ClientUpdate.exe update