After diligently and habitually backing up my TM10 data with the File/Backup procedure, I ran across the following information: "Backing up in Time Matters only includes the Administrative Files (that is, not the Main and Supporting Records) unless a SQL Stored Procedure named "TM_BACKUP" has been created to back up the Main and Supporting records." http://pm.lexisnexis.com/store/teb10/faq.asp#3.9 (para. 2) (retrieved Sept. 23, 2011).
How/where can I obtain the code for the TM_BACKUP SQL stored procedure? (Which I can execute through the SQL Server Management Studio, right?)
Joseph Nierenberg Nierenberg Employment Law, PLLC Consulting – Litigation – Training Minneapolis, Minnesota www.nierenberg.com
Joseph,
I apologize for not providing this to you on the spot - I have been scouring this computer looking for the scripts I use but cannot come up with them.
You can msg me through this site if you wish and I'll respond to it with my SQL logon scripts. They work very well.
pb
Peter Barclay MCP, MS Small Business Specialist TM11 CIC PCN, Anchorage, AK * Win Svr 2008/7/Vista Business/Vista Ultimate x64 * Microsoft Partner * Citrix Partner * Dell Premier partner
Joseph, If you are backing up from File>Backup in Time Matters, you are backing up your SQL, Time Matters data. This is represented as a .bak file. There are many other ways to backup SQL data outside of Time Matters. If you are properly managing the backup of your Time Matters shared folder and the SQL backup files, you should have what you need to restore Time Matters. Thee reference you found is for the command line to use a program such as Windows Scheduler to automate your SQL backups. You should be able to find more info under Scheduling SQL backups.
Richard B. Marx MME Consulting Services, LLC Lexis Nexis Time Matters Certified Independent Consultant (CIC) Moderator Phoenix, AZ 602-667-5706 info@mmeonline.net http://www.mmeonline.net/