CIC Solutions Forums
Certified Independent Consultant Solutions Forums for
LexisNexis® Practice Management Products
Time Matters - PCLaw - Billing Matters - Browser Edition - HotDocs

In-app backup procedure and SQL stored backup procedure

rated by 0 users
This post has 2 Replies | 3 Followers

Top 100 Contributor
Posts 38
Joseph Nierenberg Posted: Fri, Sep 23 2011 2:07 PM

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

Top 50 Contributor
Posts 78
.CIC
TM CIC

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

Top 10 Contributor
Posts 589
.CIC
BM CIC
BMP CIC
TM CIC

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/

Page 1 of 1 (3 items) | RSS