Attix5 Pro FAQ
Search:     Advanced search

Configuring Attix5 Pro to back up SharePoint 2003

Article ID: 101
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.
  3. Unlike SharePoint 2010 or 2007 (or their WSS equivalents) the Site Collection Administrator page is not advertised within SharePoint 2003. Connect to the following page on your SharePoint machine: http://ServerName/_layouts/1033/Siteusrs.aspx.
  4. Select the checkbox next to the service user, and click on the user itself.

2003 Site Settings1.png

Click Edit User Information.

2003 Site Settings2.png

Select the Site collection administrator checkbox and click Save and Close.

2003 Site Settings3.png

Navigate back to the first page (by re-entering the page name directly into the address bar) to confirm that the settings are correct.

2003 Site Settings4.png

Depending on the level of security on your SharePoint server’s SQL instance, you may need to assign permissions to the service user within SQL. Using SQL Management Studio, you need to give the user the "db_owner" role for the SharePoint Config database and the SharePoint Site database. These can be found in the Users table under Security.

SharePoint Config database:

Sharepoint Config User.jpg

SharePoint Site database:

SharedServices content user.jpg

Add the backup service user to each database, and ensure that "db_owner" is selected as shown below.

DB owner.jpg

In the registry, grant the user read access to LocalMachine\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\. 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 will be either "Local System" or "NETWORK SERVI" 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\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 you have made your selection, click the Backup toolbar button to initiate the first backup.

Note on Windows SharePoint Services 3.0

If you are using WSS 3.0 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 instance name: \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query

The permissions to be set remain the same as above.

Article ID: 101
Last updated: 04 Jan, 2013
Revision: 2
Views: 3671
Comments: 0
Posted: 08 Feb, 2012 by Flood A.
Updated: 04 Jan, 2013 by -- .
This article was:  
Prev   Next
Article 150 - Backing up the ReportServer database to the StorageServer and...     Article 103 - Configuring Attix5 Pro to back up SharePoint 2010