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