Yes I can put this up for download. I need to tidy up the comments a bit so it's easier to understand. It will be great to get some feddback on how this can be improved.
I've now uploaded the source code for the UserControl. As mentioned in the project blurb, it was a rather hastily hacked together package so I'd be really keen to hear feedback on improvements or bug fixes which can be included for future releases.
I am happy to provide personal email to anyone who wishes to communicate.
Sorry I pulled v1.0 since I made a change. I will get v1.1 up for you tonight. I am also hoping to get the package moved into App_Data folder as suggested some time in the next week or so.
Thanks for the update. The package is definitely usefull, as I see myself taking backups during development numerous times and this becomes very handy.
If saved in a safe location (assuming App_Data is safe enough), I can see it being equally usefull for those times when you wanna take a snapshot on-the-go on production.
Agreed. As noted on the details it's not recommended to save any database backup files on a production server along with the webfiles themselves but App_Data would be the best location to move the SQLBackUP folder (and contents) to.
The exact error logged is following while backing up 1.2~1.5 gb sized database.
2015-10-29 15:06:12,039 [60] ERROR AllianceMedia.SQLBackUp.UserControls.SQLBackUp - [Thread 55] Error thrown by SQLBackUp package
System.Data.SqlClient.SqlException (0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out
at System.Data.SqlClient.SqlConnection.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:a26d5ee6-0cdd-4cc6-af0c-3a491e2e15a5
Error Number:-2,State:0,Class:11
New functionality you say.. Could it be addition of more than one connection string, to backup related/auxiliary db's from the same interface too? [crowd awaits in anticipation]
Keilo if you want to create a new thread and give a little more detail about your feature request and examples of how it would work I'll see what I can do.
I will get the source code up again at some point. v1.3 was a bit of a mad rush so I want to tidy up and comment the code properly before releasing into the wild.
Source Code
Thank you for sharing this package!
Would you be able to share the source of the DLL? as I can see we can customize specifically for particular scenario.
cheers
Hi Keilo,
Yes I can put this up for download. I need to tidy up the comments a bit so it's easier to understand. It will be great to get some feddback on how this can be improved.
Expect this in the next week or so.
Regards
Thanks Adam
looking forward!
Hi,
I've now uploaded the source code for the UserControl. As mentioned in the project blurb, it was a rather hastily hacked together package so I'd be really keen to hear feedback on improvements or bug fixes which can be included for future releases.
I am happy to provide personal email to anyone who wishes to communicate.
Many thanks
Adam
Hi adam,
thats great! where can i download the source? cant seem to locate on the project page or resources. is it pulled back?
without the seeing the code one key feedback would be to change the storage location, like App_Data, so it wont be exposed to public.
This will come very handy in development environments, as well as production if App_Data is used - to get a snapshot of db before any changes.
cheers
Hi Keilo,
Sorry I pulled v1.0 since I made a change. I will get v1.1 up for you tonight. I am also hoping to get the package moved into App_Data folder as suggested some time in the next week or so.
Glad you like the package though.
Regards
Adam
Hi again Adam
Thanks for the update. The package is definitely usefull, as I see myself taking backups during development numerous times and this becomes very handy.
If saved in a safe location (assuming App_Data is safe enough), I can see it being equally usefull for those times when you wanna take a snapshot on-the-go on production.
cheers
Agreed. As noted on the details it's not recommended to save any database backup files on a production server along with the webfiles themselves but App_Data would be the best location to move the SQLBackUP folder (and contents) to.
Cheers
Thanks this is a great package.
One request though. I have a rather big database and the backup times out. Is it possible that you can set the timeout to infinite
Anton did you find any solution for the timeout?
I just came across this while attempting to backup a 1.2GB database.
Not sure which timeout setting need to be edited..
Hi guys,
I'll take a look at this. Did you receive any specific errors?
Anton how big was your database?
Hi Adam!
The exact error logged is following while backing up 1.2~1.5 gb sized database.
Thanks Keilo.
I'll run some tests and get back to you.
Thanks for the swift reply. Looking forward!
Hi,
I have a solution to this now.
I am just packing up the code and testing everything. There's some new functionality in the next release too.
Expect this early next week (Monday hopefully).
Thanks
Thats great to hear Adam. Keep us posted!
New functionality you say.. Could it be addition of more than one connection string, to backup related/auxiliary db's from the same interface too? [crowd awaits in anticipation]
OK v1.3 is now up.
Keilo if you want to create a new thread and give a little more detail about your feature request and examples of how it would work I'll see what I can do.
Thanks for the update Adam. The timeout issue is solved! This works great now if the sql is on the same server with the web app.
Noticed the source code link is removed, is there a particular reason for it?
I will open another thread on feature request/discussion.
many thanks!
Hi,
Glad it works for you now.
I will get the source code up again at some point. v1.3 was a bit of a mad rush so I want to tidy up and comment the code properly before releasing into the wild.
Watch this space!
For the sake of brevity I've dumped the source for the control and class in use into a zip file.
I do still need to tidy this up and take out a bunch of extraneous chaff in the code, but this should give you something to play with.
Apologies for the delay!
Thanks for following up and taking the time to share this. Appreciated.
I'll play with the remote db use-case and report back my findings.
cheers
is working on a reply...