Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Johan 188 posts 380 karma points
    May 11, 2016 @ 08:34
    Johan
    0

    An error has occurred during the backup

    I'm running SQLBackUp 1.3 on Umbraco v. 7.2.2. When pressing the backup-button i get this message.

    An error has occurred during the backup

    And when checking the logs they say this:

    Date    ons, 11 maj 2016, 10:15:22
    Level   ERROR
    Logger  AllianceMedia.SQLBackUp.UserControls.SQLBackUp
    Thread  No: , Id: 91
    Error thrown by SQLBackUp package
    System.Data.SqlClient.SqlException (0x80131904): Cannot open backup device '...cut_path...\wwwroot\App_Data\SQLBackUp\xxx_umbraco_20160511_101522.bak'. Operating system error 3(The system cannot find the path specified.).
    BACKUP DATABASE is terminating abnormally.
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
       at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
       at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
       at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
       at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
       at AllianceMedia.SQLBackUp.UserControls.SQLBackUp.btnRun_Click(Object sender, EventArgs e)
    ClientConnectionId:d2ab2d9b-a926-4960-845b-3ead1ac2530d
    Error Number:3201,State:1,Class:16
    

    I don't have very much control over the hosting (thats why i'm trying to make backups with this package). Any theories on why it might be failing. Feels like it should throw an error before is starts looking for the backup. Because the backup-folder is empty.

  • Adam Maidment 54 posts 163 karma points
    May 11, 2016 @ 08:56
    Adam Maidment
    1

    Thanks Johan.

    I'll take a look at this and get back to you.

  • Ferry Meidianto 36 posts 63 karma points
    May 11, 2016 @ 11:52
    Ferry Meidianto
    1

    Try providing enough permission to the \wwwroot\App_Data\SQLBackUp\ folder.

    Make sure the "Network Service" (or any identity user that's used in AppPool) has access to that folder.

    You can consult with your hosting provider if you can't change the permission yourself.

  • Adam Maidment 54 posts 163 karma points
    May 11, 2016 @ 12:33
    Adam Maidment
    0

    Yes Ferry's response would be the first thing to try if you've not already. Let me know if you still have issues afterwards and I'll run some checks.

  • Gerry Smith 13 posts 73 karma points
    Jun 16, 2017 @ 21:12
    Gerry Smith
    0

    I'm getting this as well. Umbraco: 7.6.3 SQLBackUp: 1.3

    I have granted Full Control of App_Data and subfolders to the App Pool Identity. Also note the path is correct, exists, and permissions are applied.

    Error:

        Error thrown by SQLBackUp package
    System.Data.SqlClient.SqlException (0x80131904): Cannot open backup device 'G:\PleskVhosts\--snip--\App_Data\SQLBackUp\tcon_20170616_140712.bak'. Operating system error 3(The system cannot find the path specified.).
    BACKUP DATABASE is terminating abnormally.
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
       at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
       at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
       at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
       at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
       at AllianceMedia.SQLBackUp.UserControls.SQLBackUp.btnRun_Click(Object sender, EventArgs e)
    ClientConnectionId:bc5cf246-b717-4f50-b394-e9d05d5a6be9
    Error Number:3201,State:1,Class:16
    
  • Adam Maidment 54 posts 163 karma points
    Jun 20, 2017 @ 08:39
    Adam Maidment
    0

    Hi Gerry,

    I can confirm the package works on 7.6.3 within a full trust environment, so that clears up any potential issues with Umbraco Core.

    Can you give me a little detail about the server and SQL version you are on, please? Shared hosting packages tend to have stricter permissions which can prevent the file from being created in the first place.

Please Sign in or register to post replies

Write your reply to:

Draft