Note: The SharePoint plug-in is not supported in V7. For documentation detailing how to back up SharePoint in V7, visit the Partner Area.
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, navigate to Site Settings.
Navigate to Site Collection Administrators.
Enter the backup service username and click OK.
Using SQL Management Studio, give the user the "db_owner" role for the SharePoint Config database, the Shared Services Content database and WSS Content databases. These can be found in the Users table under Security.
SharePoint Config database:
Shared Services Content database:
WSS Content database:
Add the backup service user to each database and ensure that db_owner is selected as shown below.
In the registry, grant the user read access to LocalMachine\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\12.0\. Without this permission, errors will occur.
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).
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\12.0\Secure\ConfigDB\dsn.
SharePoint should appear in the Backup Selection tab.
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:
The permissions to be set remain the same as above.