Backup of Sharepoint 2007 fails with error code 0xe000942a

Hello everyone,

We just solved an issue with Symantec Technical Support and I would like to share the solution with you guys since it's currently not possible to find the solution anywhere else.

Since I'm not allowed to add a reply to the following thread with the same error code (another resolution) I might as well create a new one.
https://www-secure.symantec.com/connect/forums/error-backing-sharepoint-2007-sp2-error-code-no-exact-matches-found-v-79-57344-37930

 

Issue

The issue was that we were trying to back up a Sharepoint 2007 farm but the backup failed instantly. The message below is found in the job log.

Error code: 0xe000942a
The job failed with the following error: Backup Exec did not find any virtual
machines to dynamically include in the backup.
V-79-57344-37930

The account used for backups was in the Domain Admins group and was added as System Administrator on both the databases as well as Farm Administrator in Sharepoint.

 

OS and application details

Backup server (physical):
Windows 2008 R2
Backup Exec 2010 R2 (up to date as of 13th Jan 2011)

SharePoint server (physical):
Windows 2003 Enterprise x64 SP2
SharePoint 2007 SP2 (12.0.0.6421)

Database servers (both physical):
SQL-A: Windows 2003 SP2 x64 and MSSQL 2005 SP3, (9.00.4053.00)
SQL-B: Windows 2008 SP2 x64 and MSSQL 2008 SP2, (10.0.4000.0)

 

Solution

Using the MS SQL Studio; add the account used for backups as "db_owner" for all Sharepoint databases. System admin is simply not enough.

That's it! Try to run the backup again.

 

For reference, Symantec Technical Support case number: 413-556-131