Alpha Software Mobile Development Tools:   Alpha Anywhere    |   Alpha TransForm subscribe to our YouTube Channel  Follow Us on LinkedIn  Follow Us on Twitter  Follow Us on Facebook

Announcement

Collapse

The Alpha Software Forum Participation Guidelines

The Alpha Software Forum is a free forum created for Alpha Software Developer Community to ask for help, exchange ideas, and share solutions. Alpha Software strives to create an environment where all members of the community can feel safe to participate. In order to ensure the Alpha Software Forum is a place where all feel welcome, forum participants are expected to behave as follows:
  • Be professional in your conduct
  • Be kind to others
  • Be constructive when giving feedback
  • Be open to new ideas and suggestions
  • Stay on topic


Be sure all comments and threads you post are respectful. Posts that contain any of the following content will be considered a violation of your agreement as a member of the Alpha Software Forum Community and will be moderated:
  • Spam.
  • Vulgar language.
  • Quotes from private conversations without permission, including pricing and other sales related discussions.
  • Personal attacks, insults, or subtle put-downs.
  • Harassment, bullying, threatening, mocking, shaming, or deriding anyone.
  • Sexist, racist, homophobic, transphobic, ableist, or otherwise discriminatory jokes and language.
  • Sexually explicit or violent material, links, or language.
  • Pirated, hacked, or copyright-infringing material.
  • Encouraging of others to engage in the above behaviors.


If a thread or post is found to contain any of the content outlined above, a moderator may choose to take one of the following actions:
  • Remove the Post or Thread - the content is removed from the forum.
  • Place the User in Moderation - all posts and new threads must be approved by a moderator before they are posted.
  • Temporarily Ban the User - user is banned from forum for a period of time.
  • Permanently Ban the User - user is permanently banned from the forum.


Moderators may also rename posts and threads if they are too generic or do not property reflect the content.

Moderators may move threads if they have been posted in the incorrect forum.

Threads/Posts questioning specific moderator decisions or actions (such as "why was a user banned?") are not allowed and will be removed.

The owners of Alpha Software Corporation (Forum Owner) reserve the right to remove, edit, move, or close any thread for any reason; or ban any forum member without notice, reason, or explanation.

Community members are encouraged to click the "Report Post" icon in the lower left of a given post if they feel the post is in violation of the rules. This will alert the Moderators to take a look.

Alpha Software Corporation may amend the guidelines from time to time and may also vary the procedures it sets out where appropriate in a particular case. Your agreement to comply with the guidelines will be deemed agreement to any changes to it.



Bonus TIPS for Successful Posting

Try a Search First
It is highly recommended that a Search be done on your topic before posting, as many questions have been answered in prior posts. As with any search engine, the shorter the search term, the more "hits" will be returned, but the more specific the search term is, the greater the relevance of those "hits". Searching for "table" might well return every message on the board while "tablesum" would greatly restrict the number of messages returned.

When you do post
First, make sure you are posting your question in the correct forum. For example, if you post an issue regarding Desktop applications on the Mobile & Browser Applications board , not only will your question not be seen by the appropriate audience, it may also be removed or relocated.

The more detail you provide about your problem or question, the more likely someone is to understand your request and be able to help. A sample database with a minimum of records (and its support files, zipped together) will make it much easier to diagnose issues with your application. Screen shots of error messages are especially helpful.

When explaining how to reproduce your problem, please be as detailed as possible. Describe every step, click-by-click and keypress-by-keypress. Otherwise when others try to duplicate your problem, they may do something slightly different and end up with different results.

A note about attachments
You may only attach one file to each message. Attachment file size is limited to 2MB. If you need to include several files, you may do so by zipping them into a single archive.

If you forgot to attach your files to your post, please do NOT create a new thread. Instead, reply to your original message and attach the file there.

When attaching screen shots, it is best to attach an image file (.BMP, .JPG, .GIF, .PNG, etc.) or a zip file of several images, as opposed to a Word document containing the screen shots. Because Word documents are prone to viruses, many message board users will not open your Word file, therefore limiting their ability to help you.

Similarly, if you are uploading a zipped archive, you should simply create a .ZIP file and not a self-extracting .EXE as many users will not run your EXE file.
See more
See less

Anyone have any OUTSTANDING backup routines for SQL Server Express?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Anyone have any OUTSTANDING backup routines for SQL Server Express?

    My A5 V11 app is managed by a very respected hosting service and I've used them for years. Generally with great results. I pay extra fees to have their services backup my entire site and SQL. That's okay but I have a desire to get my entire SQL DB or selected Tables to my local developer machine.

    Having such "real world" data (locally) will help me in developing enhancements to the major app. Because the data is local, I do not fear changes in the same manner as I might if I simply "pointed" to the remote "production" data.

    Maybe someone out there has been in a similar scenario and maybe they have spent the time to build a really robust and reliable procedure(s) to get that data to their local machine. Maybe such individuals would be willing to share their thoughts on this matter.

    I feel I have the skill set to build such an animal but I don't wish to reinvent the wheel. My desires are not really unique but I feel that
    any existing procedure(s) will prove to be better tested.

    Thanks in advance...
    Last edited by Fulltimer; 06-02-2016, 06:24 PM. Reason: fix title typo

    #2
    Re: Anyone have any OUTSTANDING backup routines for SQL Server Express?

    Hi Tom

    This works for me!

    Create a text file with this and save as a .bat file and run

    Code:
    sqlcmd -S [COLOR="#FF0000"]SERVERNAME\INSTANCENAME[/COLOR] -E -Q "EXEC sp_BackupDatabases @backupLocation=[COLOR="#FF0000"]'x:\SQLBackups\'[/COLOR], @backupType='F'"
    Replace the text in red with the SQLEXPRESS server instance (including server name) and the location to save the backups (make sure the location exists)

    Regards

    Glen
    Glen Schild



    My Blog

    Comment


      #3
      Re: Anyone have any OUTSTANDING backup routines for SQL Server Express?

      Originally posted by glenschild View Post
      Hi Tom

      This works for me!

      Create a text file with this and save as a .bat file and run

      Code:
      sqlcmd -S [COLOR="#FF0000"]SERVERNAME\INSTANCENAME[/COLOR] -E -Q "EXEC sp_BackupDatabases @backupLocation=[COLOR="#FF0000"]'x:\SQLBackups\'[/COLOR], @backupType='F'"
      Replace the text in red with the SQLEXPRESS server instance (including server name) and the location to save the backups (make sure the location exists)

      Regards

      Glen

      Glen,

      Thanks so much for your "straight to the point" reply to my post. Just a couple of related issues in implementing such a routine.

      - I'll need to "research" the switches to see exactly what they do, I may or may not wish to use them.
      - This code seems to save solely to the local drive in which the batch file is running. I'll need to create some FTP routine(s) to get the file(s) to my local machine.
      - Do you have any "local code" that can import those newly saved backups into the local Server Instance.

      Such a complete system will surely be effective in assuring a (development) work environment that could prove to be very productive.

      Tom

      Comment


        #4
        Re: Anyone have any OUTSTANDING backup routines for SQL Server Express?

        I use a commercial product to back up my MySQL/MariaDB databases, and they have a sister product designed for MS SQL. I put a screenshot of my installation. You can see that it backs up the selected databases, and sends the back up to both a local location and also to an FTP location.

        http://sqlbackupandftp.com/
        Attached Files
        Steve Wood
        See my profile on IADN

        Comment


          #5
          Re: Anyone have any OUTSTANDING backup routines for SQL Server Express?

          Steve is it better (in your opinion) to install that on the same server as my MySql database or should I install here on my home PC and use it from here to make automatic offsite backups? I plan on using my google storage account to store my backups. I looked in their forums but couldn't get a definitive answer, also have you actually used the product to restore from a backup?
          NWCOPRO: Nuisance Wildlife Control Software My Application: http://www.nwcopro.com "Without forgetting, we would have no memory at all...now what was I saying?"

          Comment


            #6
            Re: Anyone have any OUTSTANDING backup routines for SQL Server Express?

            Originally posted by Fulltimer View Post
            Glen,

            Thanks so much for your "straight to the point" reply to my post. Just a couple of related issues in implementing such a routine.

            - I'll need to "research" the switches to see exactly what they do, I may or may not wish to use them.
            - This code seems to save solely to the local drive in which the batch file is running. I'll need to create some FTP routine(s) to get the file(s) to my local machine.
            - Do you have any "local code" that can import those newly saved backups into the local Server Instance.

            Such a complete system will surely be effective in assuring a (development) work environment that could prove to be very productive.

            Tom
            Hi Tom

            I use this routine with windows scheduler to create full back ups of each database for a sql server instance. I also run another batch file that removes backups older than X days.

            Steve's suggestion works, another solution if you have the paid version of navicat is to create a batch job that backs everything up on a schedule and can send emails. It can also run from local pc if you can connect to the remote db so saving backups locally.
            Glen Schild



            My Blog

            Comment


              #7
              Re: Anyone have any OUTSTANDING backup routines for SQL Server Express?

              i am thinking that you really do not need another backup, you just need current data in your development machine to test the results before publishing to the production.
              so if you have mySql then you can log into the server and dump the database to a sql file and copy that file or send via email to yourself and execute locally and all your data will be current as of that time. similar functionality is available in sql server as glen pointed out. if you have navicat then it is a matter of connecting to the remote server (remote connection, execution should be enabled) and dump the sql file to your machine and execute the same sql file in your machine to reconstruct the database and it should be current as of that time in mysql. these i do all the time, and there is another i haven't set it up yet.
              master-slave database.
              if you set up your development computer database as slave database to the master database at the server then the slave is updated and current all the time.
              thanks for reading

              gandhi

              version 11 3381 - 4096
              mysql backend
              http://www.alphawebprogramming.blogspot.com
              [email protected]
              Skype:[email protected]
              1 914 924 5171

              Comment

              Working...
              X