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.
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.
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.
And when checking the logs they say this:
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.
Thanks Johan.
I'll take a look at this and get back to you.
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.
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.
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:
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.
is working on a reply...