Pre-requisites for the logon account used to backup Microsoft Office SharePoint Server MOSS 2007 / MOSS 2010.

Article:TECH75907

Created: 2009-01-23

Updated: 2011-08-25

Article URL http://www.symantec.com/docs/TECH75907

Article Type
Technical Solution

Product(s)

Show all

Languages

Show all

Problem

Pre-requisites for logon account for SharePoint backups and Backup Exec Service Account (BESA) to backup Microsoft Office SharePoint Server (MOSS) 2007 / MOSS 2010.

Solution

Following permissions and SQL Roles should be assigned to the Logon account for SharePoint and Backup Exec Service Account (BESA) to backup MOSS 2007.

1. Local Administrator on the WebServer and Database Server.

2. The account should be part Sharepoint Farm Administrators Group. To add the account to the Farm Administrators group please refer the document below.

   www.symantec.com/docs/TECH68711

3. The account should be "Site Collection Administrator" at the top-level site. To make the account a "Site Collection Administrator" refer the document below.

   www.symantec.com/docs/TECH70874

4. The account should have "db_owner" role on the Content databases. To provide "db_owner" role on the Sharepoint database refer the document below.

   www.symantec.com/docs/TECH66396

5. For disaster recovery it's recommended to backup the SQL instance, and the system databases along with the SharePoint DBs.

www.symantec.com/docs/HOWTO24069

NOTE : Eventually only one account can be Site Collection Administrator [ Owner ] in Sharepoint . So , Locations might not prefer to change that account to BESA . Rather , add Site Collection Administrator in Backup Exec and then assign all the BESA privilages to that account and then accordingly add permissions on SQL server as well.

Supplemental Materials

Source	UMI
Value	V-79-40960-744
Description	Backup Exec cannot restore the security for Failed to set security on List item . Ensure that the logon account has the appropriate credentials, and then try again.