SQL or File backup shows exceptions - Error: SPDBName is a component of a SharePoint server farm. It must be backed up using the Backup Exec Agent for Microsoft SharePoint Portal Server.

Article:TECH196215  |  Created: 2012-09-06  |  Updated: 2013-07-25  |  Article URL http://www.symantec.com/docs/TECH196215
NOTE: If you are experiencing this particular known issue, we recommend that you Subscribe to receive email notification each time this article is updated. Subscribers will be the first to learn about any releases, status changes, workarounds or decisions made.
Article Type
Technical Solution


Issue



This technote is applicable to exceptions showing up during SQL agent or file backups of Sharepoint SQL servers after applying Hotfix 180964 to Backup Exec.  With Sharepoint agent backups being successfully performed, a SQL agent or File backup of the SQL server hosting the Sharepoint databases will show the following exceptions for all Sharepoint databases: 


Error



SQL Agent backup error (with DB name):

79-57344-33925 - Error: SharepointSQLDB is a component of a SharePoint server farm. It must be backed up using the Backup Exec Agent for Microsoft SharePoint Portal Server. Select it for backup from the Microsoft Server SharePoint Server Farms node.

File backup error (with filename instead of DB name):

V-79-57344-33925 - Error: SharePointSQLDB.mdf is a component of a SharePoint server farm. It must be backed up using the Backup Exec Agent for Microsoft SharePoint Portal Server. Select it for backup from the Microsoft Server SharePoint Server Farms node.
 


Cause



Normally, when Sharepoint SQL databases are backed up via the Backup Exec Sharepoint agent, an exclusion is automatically added for the SQL agent and file backups so that no exceptions are received during those backups.  The databases are simply silently skipped because they are being protected by the Sharepoint agent.  In this case, the exclusions are not working properly and the SQL agent or file backup does not detect that the Sharepoint databases are being protected so the exceptions are received.

 


Solution



A hotfix is now available for this issue in the current version(s) of the product(s) mentioned in this article. Refer to the Hotfix link under Related Documents at the end of this article to obtain the hotfix needed to resolve the issue.

Backup Exec 2012 Rev 1798 Service Pack 2 (TECH203155)
 


Supplemental Materials

SourceETrack
Value2922981
Description

SPS: After applying HF8, SQL DB backups give exceptions on SPS DBs even after SPS agent backups have been performed.




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


Terms of use for this information are found in Legal Notices