locked
Farm backup error when scheduled using powershell RRS feed

  • Question

  • Getting the following error in the Farm backup log when scheduled using powershell. However,from the central admin, it is working fine.

    1) Object WSS_Content_ failed in event OnBackup. For more information, see the spbackup.log or sprestore.log file located in the backup directory. 
    SqlException: BACKUP DATABASE permission denied in database 'WSS_Content_'. 
    BACKUP DATABASE is terminating abnormally.

    2) 

    Object BDC_ServiceDB failed in event OnBackup. For more information, see the spbackup.log or sprestore.log file located in the backup directory. 
    SqlException: Cannot open database "BDC_ServiceDB" requested by the login. The login failed. 
    Login failed for user ''.

    Wednesday, July 22, 2020 5:05 AM

Answers

  • Yes, the account did  not have sufficient permission.
    • Marked as answer by ghsajith Saturday, August 1, 2020 11:19 AM
    Saturday, August 1, 2020 11:19 AM

All replies

  • Hi, ghsajith,

    According to your description, it seems that you are using a service account not having enough permission to access the backup folder. As you mentioned it works fine in CA while in powershell it returns error, make sure you are running PowerShell as administrator. 

    Quote from a similar thread:

    This error tells me that your service account does not have permission on the Backup folder. Make sure
    Service account under which you running the backup have read/write permission on the folder.
    SQL server Service account should have permission on that folder.
    I would always use the UNC path rather than local folder. 

    Reference: https://sharepoint.stackexchange.com/questions/171127/unable-to-backup-our-sharepoint-content-database-backup-database-is-terminating

    If this does not help, have a check on the spbackup.log for more information on the error.

    Please Note: Since the web site is not hosted by Microsoft, the link may change without notice. Microsoft does not guarantee the accuracy of this information.

    This “SharePoint Server 2019” Forum will be migrating to a new home on Microsoft Q&A, please refer to this sticky post for more details.

    Best Regards

    Jerry


    "SharePoint" forums will be migrating to a new home on Microsoft Q&A !
    We invite you to post new questions in the "SharePoint" forums' new home on Microsoft Q&A !

    • Proposed as answer by Michael Han6 Tuesday, July 28, 2020 6:26 AM
    Thursday, July 23, 2020 2:42 AM
  • Hi, ghsajith,

    After a few days, is there any update about your issue?

    Best Regards

    Jerry


    "SharePoint" forums will be migrating to a new home on Microsoft Q&A !
    We invite you to post new questions in the "SharePoint" forums' new home on Microsoft Q&A !

    Friday, July 31, 2020 8:56 AM
  • Yes, the account did  not have sufficient permission.
    • Marked as answer by ghsajith Saturday, August 1, 2020 11:19 AM
    Saturday, August 1, 2020 11:19 AM
  • Hi,

     

    Thanks for your response.

     

    All English SharePoint forums will be migrating to a new home on Microsoft Q&A . If you have any questions about SharePoint, welcome to post it on the new home.

     

    Best Regards

    Jerry


    "SharePoint" forums will be migrating to a new home on Microsoft Q&A !
    We invite you to post new questions in the "SharePoint" forums' new home on Microsoft Q&A !

    Monday, August 3, 2020 7:24 AM