Copied to clipboard

Flag this post as spam?

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


  • keilo 568 posts 1023 karma points
    Nov 08, 2014 @ 09:47
    keilo
    3

    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

  • Adam Maidment 54 posts 163 karma points
    Nov 09, 2014 @ 13:55
    Adam Maidment
    2

    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

  • keilo 568 posts 1023 karma points
    Nov 11, 2014 @ 17:14
    keilo
    0

    Thanks Adam

    looking forward!

  • Adam Maidment 54 posts 163 karma points
    Nov 12, 2014 @ 10:38
    Adam Maidment
    0

    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 

  • keilo 568 posts 1023 karma points
    Nov 16, 2014 @ 16:00
    keilo
    0

    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

     

  • Adam Maidment 54 posts 163 karma points
    Nov 17, 2014 @ 16:57
    Adam Maidment
    0

    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 

  • keilo 568 posts 1023 karma points
    Nov 17, 2014 @ 17:22
    keilo
    0

    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

  • Adam Maidment 54 posts 163 karma points
    Nov 17, 2014 @ 17:27
    Adam Maidment
    0

    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

  • Anton Oosthuizen 206 posts 486 karma points
    Nov 26, 2014 @ 10:45
    Anton Oosthuizen
    0

    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

  • keilo 568 posts 1023 karma points
    Oct 29, 2015 @ 17:35
    keilo
    0

    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..

  • Adam Maidment 54 posts 163 karma points
    Oct 29, 2015 @ 17:54
    Adam Maidment
    0

    Hi guys,

    I'll take a look at this. Did you receive any specific errors?

    Anton how big was your database?

  • keilo 568 posts 1023 karma points
    Oct 29, 2015 @ 17:56
    keilo
    0

    Hi Adam!

    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
    
  • Adam Maidment 54 posts 163 karma points
    Oct 29, 2015 @ 18:00
    Adam Maidment
    0

    Thanks Keilo.

    I'll run some tests and get back to you.

  • keilo 568 posts 1023 karma points
    Oct 29, 2015 @ 18:01
    keilo
    0

    Thanks for the swift reply. Looking forward!

  • Adam Maidment 54 posts 163 karma points
    Oct 31, 2015 @ 22:02
    Adam Maidment
    0

    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

  • keilo 568 posts 1023 karma points
    Nov 01, 2015 @ 10:36
    keilo
    0

    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]

  • Adam Maidment 54 posts 163 karma points
    Nov 02, 2015 @ 13:15
    Adam Maidment
    1

    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.

  • keilo 568 posts 1023 karma points
    Nov 02, 2015 @ 21:30
    keilo
    1

    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!

  • Adam Maidment 54 posts 163 karma points
    Nov 04, 2015 @ 07:38
    Adam Maidment
    0

    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!

  • Adam Maidment 54 posts 163 karma points
    Dec 15, 2015 @ 11:12
    Adam Maidment
    0

    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!

  • keilo 568 posts 1023 karma points
    Dec 15, 2015 @ 14:30
    keilo
    0

    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

Please Sign in or register to post replies

Write your reply to:

Draft