I am recently implemented a TM 10 backup plan. It backs up data as well as the SQL Server.
1. Because I have a standalone, I am unable to create a backup of SQL without exiting the program. I have a scheduled backup via MS Scheduler. It does not work if TM 10 is open. Any method automatically close the program at the time of the backup?
2. How do you backup the SQL Data folder? Certain files are always in use and are skipped.
1. Using a DOS batch file, you can create a little program that runs a MS SQL Server stored procedure included in the Time Matters database, TM_Backup. You can use the Microsoft Task Scheduler to run the little program regularly. It creates a MS SQL Server backup of your Time Matters database, a .BAK file, whether Time Matters is running or not. For example, you can set it to run once per hour so that in the event of a hard drive failure or other problem, you have a very recent backup.
2. If you create a MS SQL Server backup of Time Matters regularly, you do not have to backup the SQL data folder, but I still recommend that you do so in order to have redundant protection. You can backup open files using leading backup software utilities and online backup services.
We run Active Online Backup, a separate backup business providing products, support and assistance to small law offices.
Wells Anderson, JD, CIC / Moderator800.575.0007 - Edina, MN - © 2012
www.activepractice.comFree Time Matters Webinars monthly on the second Friday