OTB Consulting

  • Home
  • About OTB
    • Our Story
    • Team OTB
    • Awards
  • Services
    • Technology Guidance
    • Software Implementation
    • Training
  • Solutions
    • Practice Management
    • Document & Email Management
    • Time, Billing & Accounting
  • Products
    • Practice Management
      • Time Matters / Billing Matters
      • Tabs3 / PracticeMaster
      • Actionstep
      • Centerbase
      • Clio
      • BKexpress
    • Document & Email Management
      • NetDocuments
    • Time & Billing
      • PCLaw
      • Tabs3
      • Actionstep
      • Centerbase
    • Office 365
    • Consumer Bankruptcy
      • BKexpress
      • BKexpress Cloud
      • BKeTouch
      • BKecf
    • Practice Area Templates
      • U.S. Litigation Packs
      • Time Matters Litigation Pack
      • Insurance Defense
    • TM Touch
    • TM Tools
  • Resources
    • Downloads
    • OTB Technical Support
  • Contact Us
  • Blog
You are here: Home / Data Backup & Restore / Backing up your SQL Data – SQLBackupAndFTP

February 28, 2015 By Tom Rowe 2 Comments

Backing up your SQL Data – SQLBackupAndFTP

SqlBakLogo_400x400While this post may be helpful to any user of software that stores its data in a Microsoft SQL Server (MS SQL), it will be most applicable to OTB’s Time Matters users.

When you store your data in MS SQL, you obviously have to make sure it gets backed up. For many years, Time Matters did a fairly poor job at providing a robust backup solution. Most Time Matters consultants looked for alternatives outside the program, and many of us were pleased to find SQLBackupAndFTP. Even as the internal backup capabilities improved in recent versions of Time Matters, it doesn’t come close to what you can do with SQLBackupAndFTP and there is still no reason to use the internal backup solution when such a robust solution exists and is free.

There are a number of reasons this is a great piece of software, but toward the top of the list is that they provide a free version that will likely be sufficient for most time Matters users. At OTB we use their paid-for version as we need to backup more than 2 databases, want the expanded online storage alternatives, and want to encrypt our backups. But, if all you need to is to backup Time Matters, and perhaps one other database, it is free of charge.

It is very easy to configure and use. Here is a video showing you how to download it, install it, configure it and run your first backup in 2 minutes.

When we first started using it several years ago we liked it because it enabled us to FTP a copy of the backup file (it zips the backup) to a FTP site – hence the name SQLBackupAndFTP. Over the years the online storage market has matured and become a very competitive, and this great program has kept up with current events. Today you can easily have your backups uploaded to all the standard online, offsite, file repositories – Dropbox, Box, Google Drive, Amazon S3, OneDrive, and Azure. When a terabyte of data space can now be had for under $100 per year, there is no excuse to not have years of data backups available to you should you need them.

What else is there to like?

  • The free version will backup to FTP, Dropbox and Box … if you want to use any of the other services, you will need to purchase the Standard version ($59).
  • If you want to encrypt your online backups – I’d say that is a good idea – you will need the Professional version ($69).
  • You can backup to multiple locations – a local drive, FTP server, and Dropbox, as an example.
  • Any type of automated backup has to have an email notification system – check.
  • Time Matters users know that there are “supporting” files that aren’t in the MS SQL database. SQLBackupAndFTP can back those files up as well.
  • Works with SQL Server (Express) 2005, 2008 and 2012.

A full list of the features, as well as pricing can be found here.

Over the years I’ve had email correspondence with the developers about a couple of issues that I wanted to explore. They were incredibly responsive and interesting developers to work with.

For anyone interested in backing up your MS SQL data – and that should be everyone who has any – SQBackupAndFTP is a great program worth your consideration.

Filed Under: Data Backup & Restore, SQL, Time Matters

Comments

  1. John Albrektson says

    September 4, 2015 at 8:22 pm

    Thank you, THANK you, for the tip on this excellent backup. Several times I’ve had to reinstall TM on a new server using bits and pieces gleaned from internet articles, and this looks like just the ticket. If you ever have a few moments you might want to write up a walk-through on reinstalling using SQLBackupAndFTP with a TM database on a new server location. I suspect it would be 1. Install but don’t open, 2. Restore databases via SQLBackupAndFTP, and 3. Adjust location of shared files and SQL Server Name as required, and 4. Run TM. At least, that’s what I’m hoping or!

    Reply
  2. Nick says

    February 28, 2018 at 2:41 pm

    Thanks, it’s very good and easy to use tool.

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Blog Categories

  • Announcements (2)
  • Awards (7)
  • Consumer Bankruptcy (3)
  • Data Backup & Restore (2)
  • Document Management Software (9)
    • NetDocuments (8)
  • Email Management (7)
    • NetDocuments (5)
  • Metrics (1)
  • News (2)
  • Paperless Office (1)
  • Practice Management Software (16)
    • ActionStep (3)
    • Time Matters (7)
  • Reporting (1)
  • SaaS (2)
  • Scanning (1)
  • Social Media (2)
    • Twitter (2)
  • SQL (1)
  • Time & Billing (1)
  • Uncategorized (2)
  • Windows 10 (2)

Blog Post Tags

ActionStep Analytics BKexpress Clio DaaS Document Management Email Overload Metrics MyCase ndOffice ransomware Reporting SaaS SimplyFile Time & Billing Time Matters

Blog Archives

  • November 2020 (1)
  • July 2020 (1)
  • May 2020 (1)
  • October 2017 (1)
  • April 2017 (1)
  • March 2017 (2)
  • January 2017 (1)
  • August 2016 (2)
  • April 2016 (1)
  • January 2016 (1)
  • August 2015 (1)
  • July 2015 (2)
  • June 2015 (1)
  • May 2015 (3)
  • April 2015 (4)
  • March 2015 (5)
  • February 2015 (1)
  • June 2014 (1)
  • March 2014 (1)
  • October 2013 (1)
  • January 2013 (1)
  • December 2012 (1)
  • September 2010 (1)
  • October 2009 (1)
  • June 2005 (1)
  • June 2004 (1)

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Get social … follow & like us!

Facebook
Twitter
Visit Us
Follow Me

Login

Resources

  • Tips & Hints
  • Videos
    • NetDocuments UI Changes Videos
  • Webinars

Contact Us

  • OTB Consulting
  • 166 Quade Drive
    Cary, North Carolina 27513
    USA
  • 919-677-1415
  • info@otb-consulting.com
  • Download vCard

Copyright © 2023 · All rights reserved - Out of the Box Developers, LLC · Log in