none
SharePoint Foundation: Error when performing a Farm Backup RRS feed

  • Question

  • Hi,

    I am trying to create a full farm backup of my organisations SharePoint Foundations installation.

    I've tried doing it via the Central Administration and PowerShell. However both ways give me errors. Here are some of the errors associated with the Central Administration way of doing a full backup:

    Requested By  Domain\Administrator 
    Start Time  1/10/2012 2:49 PM 
    Finish Time  1/10/2012 3:06 PM 
    Directory  D:\SharePoint\Backup\Test Back ups\spbr0000\ 
    Backup ID  553b4f4f-7542-4e80-b129-d3d294285486 
    Warning Count  72 
    Error Count  16 
    Failure Message  Object Query-0 (C: on SharePoint Server) failed in event OnBackupComplete. For more information, see the spbackup.log or sprestore.log file located in the backup directory.  

    I've also got error reason 15105 coming up a lot too.

    Can anyone please tell me how I overcome this problem please.

    Regards

    Stephen

    Tuesday, January 10, 2012 4:24 PM

Answers

  • You should share out a directory on the SQL Server.  Set the Share permissions to Everyone: Full Control, and then narrow down the NTFS permissions.  Remove SQLServerName\Users.  Add your SQL Server service account (the account running sqlservr.exe according to Task Manager) with Full Control NTFS permissions.  Next, add your Farm Account (the account running owstimer.exe on your SharePoint Server) with Full Control NTFS permissions.
    http://sharepoint.nauplius.net
    • Marked as answer by StephenB2011 Thursday, January 12, 2012 4:37 PM
    Thursday, January 12, 2012 2:15 PM
    Moderator

All replies

  • Review the spbackup.log file for more details on the error(s).
    http://sharepoint.nauplius.net
    Tuesday, January 10, 2012 4:37 PM
    Moderator
  • Hi Trevor,

    I've looked through the whole file and I cannot make any sense of it. The following list is the errors that where within the log file:

    _______________________________________________________________________________________________________________

    [10/01/2012 14:49:58] Warning: [SharePoint_Config] Cannot open backup device 'D:\SharePoint\Backup\Test Back ups\spbr0000\0000005C.bak'. Operating system error 5

    (failed to retrieve text for this error. Reason: 15105).

    [10/01/2012 14:50:03] Warning: [StateService_121a4c703edd4d8485f22be52edb71a5] Cannot open backup device 'D:\SharePoint\Backup\Test Back ups\spbr0000\0000005E.bak'.

    Operating system error 5(failed to retrieve text for this error. Reason: 15105).

    [10/01/2012 14:50:06] Warning: [WSS_Content] Cannot open backup device 'D:\SharePoint\Backup\Test Back ups\spbr0000\00000061.bak'. Operating system error 5(failed to

    retrieve text for this error. Reason: 15105).

    [10/01/2012 14:50:15] Warning: [SharePoint_Config] Cannot open backup device 'D:\SharePoint\Backup\Test Back ups\spbr0000\0000005C.bak'. Operating system error 5

    (failed to retrieve text for this error. Reason: 15105).

    [10/01/2012 14:50:18] Warning: [StateService_121a4c703edd4d8485f22be52edb71a5] Cannot open backup device 'D:\SharePoint\Backup\Test Back ups\spbr0000\0000005E.bak'.

    Operating system error 5(failed to retrieve text for this error. Reason: 15105).

    [10/01/2012 14:50:21] Warning: [WSS_Content] Cannot open backup device 'D:\SharePoint\Backup\Test Back ups\spbr0000\00000061.bak'. Operating system error 5(failed to

    retrieve text for this error. Reason: 15105).

    [10/01/2012 14:51:15] Warning: [SharePoint_Config] Cannot open backup device 'D:\SharePoint\Backup\Test Back ups\spbr0000\0000005C.bak'. Operating system error 5

    (failed to retrieve text for this error. Reason: 15105).

    [10/01/2012 14:51:18] Warning: [StateService_121a4c703edd4d8485f22be52edb71a5] Cannot open backup device 'D:\SharePoint\Backup\Test Back ups\spbr0000\0000005E.bak'.

    Operating system error 5(failed to retrieve text for this error. Reason: 15105).

    [10/01/2012 14:51:21] Warning: [WSS_Content] Cannot open backup device 'D:\SharePoint\Backup\Test Back ups\spbr0000\00000061.bak'. Operating system error 5(failed to

    retrieve text for this error. Reason: 15105).

    [10/01/2012 14:53:31] FatalError: Object SharePoint_Config failed in event OnBackup. For more information, see the spbackup.log or sprestore.log file located in the

    backup directory.
    SqlException: Cannot open backup device 'D:\SharePoint\Backup\Test Back ups\spbr0000\0000005C.bak'. Operating system error 5(failed to retrieve text for this error.

    Reason: 15105).

    [10/01/2012 14:53:32] Warning: [Temp2_Content] Cannot open backup device 'D:\SharePoint\Backup\Test Back ups\spbr0000\00000062.bak'. Operating system error 5(failed to

    retrieve text for this error. Reason: 15105).

    10/01/2012 14:53:33] FatalError: Object StateService_121a4c703edd4d8485f22be52edb71a5 failed in event OnBackup. For more information, see the spbackup.log or

    sprestore.log file located in the backup directory.
        SqlException: Cannot open backup device 'D:\SharePoint\Backup\Test Back ups\spbr0000\0000005E.bak'. Operating system error 5(failed to retrieve text for this

    error. Reason: 15105).

    [10/01/2012 14:53:37] FatalError: Object WSS_Content failed in event OnBackup. For more information, see the spbackup.log or sprestore.log file located in the backup

    directory.
        SqlException: Cannot open backup device 'D:\SharePoint\Backup\Test Back ups\spbr0000\00000061.bak'. Operating system error 5(failed to retrieve text for this

    error. Reason: 15105).
    BACKUP DATABASE is terminating abnormally.

    [10/01/2012 14:53:50] Warning: [Temp2_Content] Cannot open backup device 'D:\SharePoint\Backup\Test Back ups\spbr0000\00000062.bak'. Operating system error 5(failed to

    retrieve text for this error. Reason: 15105).

    [10/01/2012 14:53:52] Warning: [SharePoint_AdminContent_61a49b6b-f3d6-4b98-af1b-78ca06dc3fcf] Cannot open backup device 'D:\SharePoint\Backup\Test Back ups

    \spbr0000\00000065.bak'. Operating system error 5(failed to retrieve text for this error. Reason: 15105).

    [10/01/2012 14:54:11] Warning: [SharePoint_AdminContent_61a49b6b-f3d6-4b98-af1b-78ca06dc3fcf] Cannot open backup device 'D:\SharePoint\Backup\Test Back ups

    \spbr0000\00000065.bak'. Operating system error 5(failed to retrieve text for this error. Reason: 15105).
    BACKUP DATABASE is terminating abnormally.

    [10/01/2012 14:54:20] Warning: [Secure_Store_Service_DB_26fc8782f473423f8b6fd76ec0222ead] Cannot open backup device 'D:\SharePoint\Backup\Test Back ups

    \spbr0000\00000066.bak'. Operating system error 5(failed to retrieve text for this error. Reason: 15105).

    [10/01/2012 14:54:35] Warning: [Secure_Store_Service_DB_26fc8782f473423f8b6fd76ec0222ead] Cannot open backup device 'D:\SharePoint\Backup\Test Back ups

    \spbr0000\00000066.bak'. Operating system error 5(failed to retrieve text for this error. Reason: 15105).
    BACKUP DATABASE is terminating abnormally.

    [10/01/2012 14:54:50] Warning: [Temp2_Content] Cannot open backup device 'D:\SharePoint\Backup\Test Back ups\spbr0000\00000062.bak'. Operating system error 5(failed to

    retrieve text for this error. Reason: 15105).
    BACKUP DATABASE is terminating abnormally.

    [10/01/2012 14:55:11] Warning: [SharePoint_AdminContent_61a49b6b-f3d6-4b98-af1b-78ca06dc3fcf] Cannot open backup device 'D:\SharePoint\Backup\Test Back ups

    \spbr0000\00000065.bak'. Operating system error 5(failed to retrieve text for this error. Reason: 15105).
    BACKUP DATABASE is terminating abnormally.

    [10/01/2012 14:55:35] Warning: [Secure_Store_Service_DB_26fc8782f473423f8b6fd76ec0222ead] Cannot open backup device 'D:\SharePoint\Backup\Test Back ups

    \spbr0000\00000066.bak'. Operating system error 5(failed to retrieve text for this error. Reason: 15105).
    BACKUP DATABASE is terminating abnormally.

    [10/01/2012 14:57:05] FatalError: Object Temp2_Content failed in event OnBackup. For more information, see the spbackup.log or sprestore.log file located in the backup

    directory.
        SqlException: Cannot open backup device 'D:\SharePoint\Backup\Test Back ups\spbr0000\00000062.bak'. Operating system error 5(failed to retrieve text for this

    error. Reason: 15105).
    BACKUP DATABASE is terminating abnormally.

    [10/01/2012 14:57:08] Warning: [WebAnalyticsServiceApplication_StagingDB_2504a5a5-71bc-4046-aa29-4766c031e70f] Cannot open backup device 'D:\SharePoint\Backup\Test

    Back ups\spbr0000\00000067.bak'. Operating system error 5(failed to retrieve text for this error. Reason: 15105).
    BACKUP DATABASE is terminating abnormally.

    [10/01/2012 14:57:23] Warning: [WebAnalyticsServiceApplication_StagingDB_2504a5a5-71bc-4046-aa29-4766c031e70f] Cannot open backup device 'D:\SharePoint\Backup\Test

    Back ups\spbr0000\00000067.bak'. Operating system error 5(failed to retrieve text for this error. Reason: 15105).
    BACKUP DATABASE is terminating abnormally.

    [10/01/2012 14:57:26] FatalError: Object SharePoint_AdminContent_61a49b6b-f3d6-4b98-af1b-78ca06dc3fcf failed in event OnBackup. For more information, see the

    spbackup.log or sprestore.log file located in the backup directory.
        SqlException: Cannot open backup device 'D:\SharePoint\Backup\Test Back ups\spbr0000\00000065.bak'. Operating system error 5(failed to retrieve text for this

    error. Reason: 15105).
    BACKUP DATABASE is terminating abnormally.

    [10/01/2012 14:57:28] Warning: [WebAnalyticsServiceApplication_ReportingDB_f9e3ab00-ef34-4562-b9e6-e512ea466ad5] Cannot open backup device 'D:\SharePoint\Backup\Test

    Back ups\spbr0000\00000068.bak'. Operating system error 5(failed to retrieve text for this error. Reason: 15105).
    BACKUP DATABASE is terminating abnormally.

    [10/01/2012 14:57:43] Warning: [WebAnalyticsServiceApplication_ReportingDB_f9e3ab00-ef34-4562-b9e6-e512ea466ad5] Cannot open backup device 'D:\SharePoint\Backup\Test

    Back ups\spbr0000\00000068.bak'. Operating system error 5(failed to retrieve text for this error. Reason: 15105).
    BACKUP DATABASE is terminating abnormally.

    [10/01/2012 14:57:50] FatalError: Object Secure_Store_Service_DB_26fc8782f473423f8b6fd76ec0222ead failed in event OnBackup. For more information, see the spbackup.log

    or sprestore.log file located in the backup directory.
        SqlException: Cannot open backup device 'D:\SharePoint\Backup\Test Back ups\spbr0000\00000066.bak'. Operating system error 5(failed to retrieve text for this

    error. Reason: 15105).
    BACKUP DATABASE is terminating abnormally.

    [10/01/2012 14:57:57] Warning: [Bdc_Service_DB_9a70ba5cb7e04a7386306c203fdf9dd0] Cannot open backup device 'D:\SharePoint\Backup\Test Back ups\spbr0000\00000069.bak'.

    Operating system error 5(failed to retrieve text for this error. Reason: 15105).
    BACKUP DATABASE is terminating abnormally.

    [10/01/2012 14:58:12] Warning: [Bdc_Service_DB_9a70ba5cb7e04a7386306c203fdf9dd0] Cannot open backup device 'D:\SharePoint\Backup\Test Back ups\spbr0000\00000069.bak'.

    Operating system error 5(failed to retrieve text for this error. Reason: 15105).
    BACKUP DATABASE is terminating abnormally.

    [10/01/2012 14:58:23] Warning: [WebAnalyticsServiceApplication_StagingDB_2504a5a5-71bc-4046-aa29-4766c031e70f] Cannot open backup device 'D:\SharePoint\Backup\Test

    Back ups\spbr0000\00000067.bak'. Operating system error 5(failed to retrieve text for this error. Reason: 15105).
    BACKUP DATABASE is terminating abnormally.

    [10/01/2012 14:58:43] Warning: [WebAnalyticsServiceApplication_ReportingDB_f9e3ab00-ef34-4562-b9e6-e512ea466ad5] Cannot open backup device 'D:\SharePoint\Backup\Test

    Back ups\spbr0000\00000068.bak'. Operating system error 5(failed to retrieve text for this error. Reason: 15105).
    BACKUP DATABASE is terminating abnormally.

    [10/01/2012 14:59:12] Warning: [Bdc_Service_DB_9a70ba5cb7e04a7386306c203fdf9dd0] Cannot open backup device 'D:\SharePoint\Backup\Test Back ups\spbr0000\00000069.bak'.

    Operating system error 5(failed to retrieve text for this error. Reason: 15105).
    BACKUP DATABASE is terminating abnormally.

    [10/01/2012 15:00:39] FatalError: Object WebAnalyticsServiceApplication_StagingDB_2504a5a5-71bc-4046-aa29-4766c031e70f failed in event OnBackup. For more information,

    see the spbackup.log or sprestore.log file located in the backup directory.
        SqlException: Cannot open backup device 'D:\SharePoint\Backup\Test Back ups\spbr0000\00000067.bak'. Operating system error 5(failed to retrieve text for this

    error. Reason: 15105).
    BACKUP DATABASE is terminating abnormally.

    [10/01/2012 15:00:51] Warning: [Search_Service_Application_1_PropertyStoreDB_45c02022f59f474f951968c1af057ae0] Cannot open backup device 'D:\SharePoint\Backup\Test

    Back ups\spbr0000\0000006C.bak'. Operating system error 5(failed to retrieve text for this error. Reason: 15105).
    BACKUP DATABASE is terminating abnormally.

    [10/01/2012 15:00:51] Warning: [Search_Service_Application_1_CrawlStoreDB_1efdf6e816ac49afa9187bbe008f4ba9] Cannot open backup device 'D:\SharePoint\Backup\Test Back

    ups\spbr0000\0000006B.bak'. Operating system error 5(failed to retrieve text for this error. Reason: 15105).
    BACKUP DATABASE is terminating abnormally.

    [10/01/2012 15:00:51] Warning: [Search_Service_Application_1_DB_fff3b084e2104326a6bdf065cc1bddfe] Cannot open backup device 'D:\SharePoint\Backup\Test Back ups

    \spbr0000\0000006A.bak'. Operating system error 5(failed to retrieve text for this error. Reason: 15105).
    BACKUP DATABASE is terminating abnormally.

    [10/01/2012 15:00:59] FatalError: Object WebAnalyticsServiceApplication_ReportingDB_f9e3ab00-ef34-4562-b9e6-e512ea466ad5 failed in event OnBackup. For more

    information, see the spbackup.log or sprestore.log file located in the backup directory.
        SqlException: Cannot open backup device 'D:\SharePoint\Backup\Test Back ups\spbr0000\00000068.bak'. Operating system error 5(failed to retrieve text for this

    error. Reason: 15105).
    BACKUP DATABASE is terminating abnormally.

    [10/01/2012 15:01:08] Warning: [Search_Service_Application_1_CrawlStoreDB_1efdf6e816ac49afa9187bbe008f4ba9] Cannot open backup device 'D:\SharePoint\Backup\Test Back

    ups\spbr0000\0000006B.bak'. Operating system error 5(failed to retrieve text for this error. Reason: 15105).
    BACKUP DATABASE is terminating abnormally.

    [10/01/2012 15:01:11] Warning: [Search_Service_Application_1_PropertyStoreDB_45c02022f59f474f951968c1af057ae0] Cannot open backup device 'D:\SharePoint\Backup\Test

    Back ups\spbr0000\0000006C.bak'. Operating system error 5(failed to retrieve text for this error. Reason: 15105).
    BACKUP DATABASE is terminating abnormally.

    [10/01/2012 15:01:11] Warning: [Search_Service_Application_1_DB_fff3b084e2104326a6bdf065cc1bddfe] Cannot open backup device 'D:\SharePoint\Backup\Test Back ups

    \spbr0000\0000006A.bak'. Operating system error 5(failed to retrieve text for this error. Reason: 15105).
    BACKUP DATABASE is terminating abnormally.

    [10/01/2012 15:01:27] FatalError: Object Bdc_Service_DB_9a70ba5cb7e04a7386306c203fdf9dd0 failed in event OnBackup. For more information, see the spbackup.log or

    sprestore.log file located in the backup directory.
        SqlException: Cannot open backup device 'D:\SharePoint\Backup\Test Back ups\spbr0000\00000069.bak'. Operating system error 5(failed to retrieve text for this

    error. Reason: 15105).
    BACKUP DATABASE is terminating abnormally.

    [10/01/2012 15:02:09] Warning: [Search_Service_Application_1_CrawlStoreDB_1efdf6e816ac49afa9187bbe008f4ba9] Cannot open backup device 'D:\SharePoint\Backup\Test Back

    ups\spbr0000\0000006B.bak'. Operating system error 5(failed to retrieve text for this error. Reason: 15105).
    BACKUP DATABASE is terminating abnormally.

    [10/01/2012 15:02:11] Warning: [Search_Service_Application_1_PropertyStoreDB_45c02022f59f474f951968c1af057ae0] Cannot open backup device 'D:\SharePoint\Backup\Test

    Back ups\spbr0000\0000006C.bak'. Operating system error 5(failed to retrieve text for this error. Reason: 15105).
    BACKUP DATABASE is terminating abnormally.

    [10/01/2012 15:02:11] Warning: [Search_Service_Application_1_PropertyStoreDB_45c02022f59f474f951968c1af057ae0] SQL command failed and needs to be restarted. The

    command will be re-started a total of three times before throwing an exception.

    [10/01/2012 15:02:11] Warning: [Search_Service_Application_1_DB_fff3b084e2104326a6bdf065cc1bddfe] Cannot open backup device 'D:\SharePoint\Backup\Test Back ups

    \spbr0000\0000006A.bak'. Operating system error 5(failed to retrieve text for this error. Reason: 15105).
    BACKUP DATABASE is terminating abnormally.

    [10/01/2012 15:04:56] FatalError: Object Search Service Application 1 failed in event OnBackup. For more information, see the spbackup.log or sprestore.log file

    located in the backup directory.
        SqlException: Cannot open backup device 'D:\SharePoint\Backup\Test Back ups\spbr0000\0000006A.bak'. Operating system error 5(failed to retrieve text for this

    error. Reason: 15105).
    BACKUP DATABASE is terminating abnormally.

    [10/01/2012 15:06:11] FatalError: Object Search_Service_Application_1_DB_fff3b084e2104326a6bdf065cc1bddfe failed in event OnBackupComplete. For more information, see

    the spbackup.log or sprestore.log file located in the backup directory.
        Aborted due to error in another component.

    [10/01/2012 15:06:12] FatalError: Object Admin (C: on SharePoint) failed in event OnBackupComplete. For more information, see the spbackup.log or sprestore.log file

    located in the backup directory.
        Aborted due to error in another component.

    [10/01/2012 15:06:13] FatalError: Object Search_Service_Application_1_CrawlStoreDB_1efdf6e816ac49afa9187bbe008f4ba9 failed in event OnBackupComplete. For more

    information, see the spbackup.log or sprestore.log file located in the backup directory.
        Aborted due to error in another component.

    [10/01/2012 15:06:13] FatalError: Object Crawl-0 (C: on SharePoint) failed in event OnBackupComplete. For more information, see the spbackup.log or sprestore.log file

    located in the backup directory.
        Aborted due to error in another component.

    [10/01/2012 15:06:15] FatalError: Object Search_Service_Application_1_PropertyStoreDB_45c02022f59f474f951968c1af057ae0 failed in event OnBackupComplete. For more

    information, see the spbackup.log or sprestore.log file located in the backup directory.
        Aborted due to error in another component.

    [10/01/2012 15:06:16] FatalError: Object Query-0 (C: on SharePoint) failed in event OnBackupComplete. For more information, see the spbackup.log or sprestore.log file

    located in the backup directory.
        Aborted due to error in another component.

    [1/10/2012 3:06:22 PM] Progress: Completed with errors and warnings, please refer to the log file for details.


    [1/10/2012 3:06:22 PM] Finished with 72 warnings.
    [1/10/2012 3:06:22 PM] Finished with 16 errors.

    [1/10/2012 3:06:22 PM] FatalError: Backup failed for Object Query-0 (C: on SharePoint) failed in event OnBackupComplete. For more information, see the spbackup.log or

    sprestore.log file located in the backup directory.

    ______________________________________________________________________________________________________________

    Hopefully you can make more sense of it than me.

    Regards,

    Stephen

    Tuesday, January 10, 2012 5:02 PM
  • Error 5 means Access is denied.  See:  http://technet.microsoft.com/en-us/library/ee748626.aspx#section1.  Validate your SQL Server service account and your Timer Service (farm admin) account have permission to write to the backup folder.
    http://sharepoint.nauplius.net
    Tuesday, January 10, 2012 5:05 PM
    Moderator
  • Are your SharePoint and SQL Server two different servers? If they are, the backup location needs to be a network share that both servers can access. The SharePoint farm account and the SQL Server service identity needs change access to the share location.

    http://technet.microsoft.com/en-us/library/ee748626.aspx


    JD Wade
    Senior SharePoint Consultant, MCTS
    Horizons Consulting, Inc.
    Blog: http://wadingthrough.com
    Twitter: http://twitter.com/jdwade
    Tuesday, January 10, 2012 9:21 PM
  • Hi guys,

    Thanks for your replys.

    I've been searching around trying to figure out how exactly I can give them two accounts privilages to write to a backup destination, by the way JD, I am running two seperates virtual servers, one for SQL and one for SharePoint.

    Can you's give me some help on how I can do this?

    Regards

    Stephen

    Thursday, January 12, 2012 9:58 AM
  • You should share out a directory on the SQL Server.  Set the Share permissions to Everyone: Full Control, and then narrow down the NTFS permissions.  Remove SQLServerName\Users.  Add your SQL Server service account (the account running sqlservr.exe according to Task Manager) with Full Control NTFS permissions.  Next, add your Farm Account (the account running owstimer.exe on your SharePoint Server) with Full Control NTFS permissions.
    http://sharepoint.nauplius.net
    • Marked as answer by StephenB2011 Thursday, January 12, 2012 4:37 PM
    Thursday, January 12, 2012 2:15 PM
    Moderator
  • Brilliant Trevor,

    Thank's a lot, that's it working now no worries.

    Regards

    Stephen

    Thursday, January 12, 2012 4:37 PM
  • I'm running on the same issue, and I wil follow your advice, but I really would like to know why we need to use a shared folder within the SQL Server, because by giving Full Control to the SQL Service Account (runing sqlserver.exe), SP_Farm (running timer) and just to be sure to the SP_Admin as well on the network share (wherever this is in), this should go smoothly, and aparently it does at some point because the process starts and files and directories are created on the shared folder; the wierd thing is that just some files like the 0000005E.bak file, cannot be created after 100's of files where previously created by the same process using the same accounts... so I don't get it...!

    So, to clarify, I want to know why just some files failed on their creation and 100's of other files where created ok. I doesn't make sense at all.

    Friday, March 30, 2012 7:46 PM
  • I just hit this issue mentioned in original post - Trevor's fix worked - thanks T.S. !!
    Thursday, January 24, 2013 6:34 PM
  • Worked for me!!! Great! Thank you so much!
    Sunday, March 17, 2013 8:48 PM
  • I had the same problem. The solution for this is to make a share. Make a folder, right-click on it >> Properties. In the tab Sharing click on Advanced Sharing.. There you can see the Share Name and under the comments box there is a button called Permissions. Give to "Everybody" Full Control Permissions. Copy the Share Name and put it in the field where SharePoint asks for Backup location. It should work now.

    PS: keep watching the Examples. It says Example:\\backup\SharePoint. This points to the fact, that the Backup location should be a Share.

    Regards

    Tuesday, February 25, 2014 12:11 PM