How to Rebuild or “Re-index” the Dentrix Database

How to Rebuild or “Re-index” the Dentrix Database

without comments

With tech support costs upwards of $130.00 an hour with Henry Schein’s Dentrix phone support and an unruly annual support fee, finding answers to simple bug fixes can be difficult. With the release of newer operating systems and lack of seamless software integration there is little to no way to get out of making that expensive call. However, here at Help Desk Computer Services we want to share as much information as possible to get you up and running with little cost to you. The following tutorial will instruct you on how to re-index your Dentrix database.

PLEASE DO AT YOUR OWN RISK – WE ASSUME NO RESPONSABILITY FOR THE FOLLOWING STEPS – THESE INSTRUCTIONS ARE FOR REFERENCE ONLY!

Symptoms:

Dentrix will act very weird in an inconsistent way; like users won’t be able to open patient charts, and it won’t index properly. The end-user explained it to us several different issues, it was difficult to pin-point what the problem was, but it turns out a re-index was the root cause. This type of problem is very common and will happen every so often, the degree to how often will depend on the size and volume of the practice.

Cause:

The symptoms are caused because each Dentrix workstation is given a unique “Session ID Number”. This number increments as each workstation turns on and connects to the database, which begins from the first time they are brought on the Dentrix network. When one of these workstations, for whatever the reason, is improperly disconnected from the network server, eg: improper shutdown or network failure, the Session ID Number will increment by 1. When this number reaches a maximum limit, weird things start happening and we must rebuild or, in other words, re-index the Dentrix database.

Resolution:

To solve this common problem, follow these seemingly complicated but very simple steps:

1. First close every Dentrix application on every workstation and server; the best way to do that is to simply shutdown all workstations.

2. Next, backup your data folder (use ep.exe tool to find path, see below), once you’ve found the correct path to your database, make a backup copy of it before we begin.

Located at C:\Dentrix\ep.exe

Dentrix Edit Path Location
Above: Location of edit path file.
Below: Show’s the path of the database directory you want to backup:
Dentrix Database Directory

3. After you’ve made a copy of the data: copy these four files from the TUTOR folder to the DATA folder. You will want to rename the current four files within the data folder to *.dat.old before you copy. The tutor folder is located locally on the server: in C:\Dentrix\TUTOR_G4.7 (your version number may differ)

COMM_DAT.DAT
DATALOK2.DAT
DATALOK.DAT
NETID.DAT

4. Run _rebuild.exe from within the c:/dentrix folder like in step 2

5. Click OK to the backup warning

6. Click “Select All” button:
Dentrix Rebuild Utility

7. Click “Rebuild” button.

Below is an example output you should see:
Rebuild for database version 14.1
Dentrix Rebuild started: 11/19/2011, 05:34:37 pm
Rebuilding Address File...
Rebuilding Aging File...
Rebuilding Appointment Events File...
Rebuilding Appointment File...
Rebuilding Appointment History File...
Rebuilding Audit Index Files...
Rebuilding Chart Paint File...
Rebuilding Claim Attachments File...
Rebuilding Claim File...
Rebuilding Claim Information File...
Rebuilding Clinical Note File...
Rebuilding Clinical Note Support File...
Rebuilding Clinical Record File...
Rebuilding Communications File...
Rebuilding Consent Forms File...
Rebuilding Cont. Care Pending File...
Rebuilding Cont. Care Setup File...
Rebuilding Cont. Care Views File...
Rebuilding Coverage Table File...
Rebuilding Definitions File...
Rebuilding Diagnostic Code File...
Rebuilding Diagnostic Cross Code File...
Rebuilding Document Center Attachments File...
Rebuilding Document Center File...
Rebuilding Document Center Type File...
Rebuilding DXPort File...
Rebuilding Employer File...
Rebuilding Fee Schedule File...
Rebuilding Gratuity Acts File...
Rebuilding Gratuity File...
Rebuilding History Viewer, Patient File...
Rebuilding History Viewer, Transaction File...
Rebuilding Image File...
Rebuilding Insurance Plan File...
Rebuilding Insured Subscriber File...
Rebuilding Lab Case Mgr Cases File...
Rebuilding Lab Case Mgr Definitions File...
Rebuilding Lab Case Mgr Information File...
Rebuilding Lab Case Mgr Labs File...
Rebuilding Lab Case Mgr Links File...
Rebuilding Lab Case Mgr Log File...
Rebuilding Lab Case Mgr Ship. Methods File...
Rebuilding Medical Code File...
Rebuilding Medical Cross Code File...
Rebuilding Medical Procedure Log File...
Rebuilding Network ID File...
Rebuilding Note File...
Rebuilding Office Journal File...
Rebuilding Pat Ed Links File...
Rebuilding Pat Ed Topics File...
Rebuilding Patient Alert File...
Rebuilding Patient Alert Link File...
Rebuilding Patient File...
Rebuilding Payment Agreement File...
Rebuilding Payment Plan File...
Rebuilding Payment Table File...
Rebuilding Perio File...
Rebuilding Prescription File...
Rebuilding Prescription Setup File...
Rebuilding Procedure Code File...
Rebuilding Procedure Log File...
Rebuilding Provider Insurance IDs File...
Rebuilding Questionaire Forms...
Rebuilding Questionaire Links...
Rebuilding Questionaire Questions...
Rebuilding Questionaire Response...
Rebuilding Questionaire Response Set...
Rebuilding Quick Labels...
Rebuilding Referral Acts File...
Rebuilding Referral File...
Rebuilding Report File...
Rebuilding Resource File...
Rebuilding Resource Use File...
Rebuilding Signature File...
Rebuilding Signed Consents File...
Rebuilding Time Clock Attachment File...
Rebuilding Time Clock Setup File...
Rebuilding Tooth Placement File...
Rebuilding Totals File...
Rebuilding Tx Case File...
Rebuilding Tx Case Link File...
Rebuilding Tx Case Status File...
Rebuilding Web Patient File...
Rebuilding Web Patient Request File...
Rebuilding Web Patient Update File...
Rebuilding Web Payment File...
Rebuilding Web Resource File...
Rebuilding Web UpRef File...
Rebuilding Wellness Index File...
Rebuilding Zip Code File...
Dentrix Rebuild complete: 11/19/2011, 05:35:40 pm

If you see “Dentrix Rebuild Complete” at the bottom, you know it’s successful.

8. After completing the rebuild, now run “_maint.exe” file located within the same C:/Dentrix directory. It should look like the window below:
Dentrix Maintenance Utility

9. Click Run option in the upper left hand corner, and select “Reset network station id’s” like below:
Dentrix Resetting Network Station Ids

10. Finally, open Dentrix one at a time on each machine within the office. It is very important to run a Dentirx module on each machine one at a time until they have all opened a module at least once.

Conclusion:

If you run into any weird errors when opening .exe files on the server, it is more than likely caused because a Dentrix module is open somewhere either on a workstation or the server. The best resolution to this is to shutdown all workstations and reboot the server.

Again, this fix isn’t a permanent fix. You will need to re-run this indexing process every so often. We understand that every-so-often is very vague but, it’s true and, it’s solely dependent upon the size and volume of your practice and how often your workstations gain new id numbers.

We hope this helps someone out in a tough spot or over the weekend when Dentrix support is closed. And if all else fails, please contact us for further assistance.

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Trixi – An Export Tool for Dentrix Users

HOME

Back to Manual Table of Contents

Trixi – An Export Tool for Dentrix Users

To use Trixi, first install the .NET framework by clicking here: http://www.softsensedata.com/dotnetfx.exe. (Select “Pract-Eze” when given a choice)

Then, install Trixi: www.softsensedata.com/TrixiSetup13.exe. (last updated 1/26/06).

Free Tech Support: www.softsensedata.com/contact.html

Source Code: www.softsensedata.com/trixi.zip (for version 0.11)

Trixi gives you direct accesss to your Dentrix database. You can either export text files or create reports by combining multiple tables.

The data in Dentrix is yours and you should have complete access to it. It would be extremely simple for Dentrix to include the ODBC driver for their database which would make it open and usable by other programs. The driver already exists, but they have chosen to intentionally prevent your access to your data with claims that your data is their proprietary property. Trixi is our response to Dentrix’s policy.

Since we realize that it is difficult for users to switch software, we are trying to give Dentrix users more control over their data so they can get a taste of what an open database can be used for. Obviously, we hope to eventually convince you that Pract-Eze Dental would be a better solution. As an added bonus, any data that we can export using Trixi, we will also be able to automatically convert from Dentrix when you switch.

Procedure-based exports are the key to generating useful reports. You can use procedure information to create production and income reports as well as to get all kinds of specific information about the kinds of procedures your office is performing. The ability to pull information from multiple tables and tie it to procedures is very powerful.

Trixi does not have any premade reports. Its main functions are to export tables and create custom reports. For advanced users, there will always be the option to simply export as many Dentrix tables as possible. Then you can load the tables into your favorite database program, like Access or MySQL to manipulate and run queries on the data.

Trixi will always remain available as a free download. Contact information: www.softsensedata.com/contact.html.

Technical Details
Originally we were going to export the raw data as-is, but Dentrix uses an antiquated database format that is not especially user friendly. For instance, all notes are stored in a separate table. So, the note that you would expect to be part of a procedure would actually have to be dug out of the notes table. Also, all addresses are in a different table from the person they are attached to. So, what we have done is to reduce the number of tables by combining all one-to-one and one-to-few relationships into single tables. Notes are now just another field in the table of interest. Definitions, like the type of payment, are converted to the most useful format, usually text. ProcedureCodes are converted from the current integer format to the expected ADA code. All simplifications are carefully considered and do not reduce the usefulness of the data.

 

 

 

 

 

 

 

 

 

 

 

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Navigating the Questionnaires Module

Navigating the Questionnaires Module

In order to effectively manage your patient forms, you must understand how to navigate and use the Questionnaires module. 

The Questionnaires List box lists the questionnaire forms that the selected patient has filled out. Based on the symbols and information contained in each column of the Questionnaires List box, you can see when the form was filled out, whether the Family File has been updated with the information in the form, whether the form requires a signature, if the for is expires, etc. 
 


The bullet points below explain the symbols and information contained in each column. 
  1. PI – This column indicates whether or not the patient information has been updated in the Family File. If this column is empty, the Family File has not been updated. A blue check mark indicates that the Family File has been updated. A dash in this column indicates the questionnaire form does not include patient information.
  2. Signed - This column indicates if the form requires a signature and if it has been signed. If this column is blank, the questionnaire form has not been signed. If this column has a signature icon, the questionnaire for has been signed. If the form contains all required signatures, the icon is red (see bottom three forms in image above). If not, the signature icon is gray (see top form in image above). If this column has a dash in it, no signature is required for the questionnaire form.
  3. Prov - This column indicates which provider is attached to the form, if any.
  4. Responses - This column displays the date the responses were entered for the form.
  5. Form Name – This columns displays the name of the form.
  6. ID - This column lists the identification number for the form. The ID number is assigned in the Questionnaires Setup.
  7. Form Date – This column displays the date the form was created.
  8. Category - This column displays the form category.
  9. Expiration - This column displays the date the form will expire and need to be filled out again. Expired form dates are red. Most forms do not have an expiration date set up by default, but you can add an expiration date in the Questionnaires Setup.
If you are viewing the Questionnaires module for all patients, you will see three additional columns:
  1. NP - This column displays a Y if this form is for a patient with a new patient appointment in the Appointment Book.
  2. Patient Name - This column displays the name of the patient whose information appears on the form.
  3. Web - This column displays a W if the form was submitted electronically via a kiosk or practice website.


 
You can sort by column by clicking on the column heading. By right-clicking, you can choose which columns to display and which columns to hide. You can also re-size and re-order the columns in the list box.
To learn more about how to manage completed forms in the Questionnaires module and how to update patient information using questionnaire responses, see the “Using the Questionnaires Module” tutorial (article #41849) in the Dentrix Resource Center, or sign up for the Paperless Patient Check-in with Dentrix and Kiosk course offered at this year’s Business of Dentistry Conference.
Visit http://businessofdentistry.com/dentrix/ for more information about the 2014 Dentrix Business of Dentistry Conference, including information on how to register for the conference, conference speakers and agenda, and a complete list of Dentrix courses being offered. 

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

New Dentrix-Integrated Kiosk Software

New Dentrix-Integrated Kiosk Software

Kiosk software is here! As part of the eCentral Web Site Manager, the new kiosk software integrates seamlessly with Dentrix to revolutionize the patient form process. Adding a kiosk to your practice has many benefits, some of which you may not have considered.

Improved Patient Data Accuracy
A patient kiosk eliminates a step from your form-completion process to improve the accuracy of your patient data. Let’s face it, everyone that inputs data from patient forms has experienced handwriting that is difficult to read. The resulting misinterpretation can lead to incorrect patient data in your system. Plus, inputting the data second-hand increases the likelihood of key-punch errors.

One constant has remained the same since the dawn of the computer age: bad information in, bad information out. Inaccurate information can impair your practice’s ability to maintain contact with patients and stabilize cash flow.

Benefits:

  • Reduces the chance of delayed or rejected claims
  • Reduces the chance of billing statements or recall cards going to the wrong address
  • Improves the ability to contact patients for appointment confirmation
  • Improves compliance with government mandates for electronic records

Update Patient Information
The front office staff can review the data submitted by the patient, import it into the patient file, and electronically sign the forms.

 

More Paperless
A patient kiosk further decreases your practice’s dependency on paper. Since you’re a Dentrix practice, you probably already appreciate many of the benefits of going paperless – many of which are outlined below. Having a kiosk eliminates ALL the paper forms that you require your patients to complete. You can add and customize forms based on the unique needs of your practice.

Benefits:

  • Reduces office clutter
  • Reduces office supplies expenses
  • Improves office access to patient data
  • Improves protection against paper record compromise
  • Reduces storage space requirements

 

Forms Completed
The Forms Completed screen summarizes which forms are complete and which are not. It also allows the patient to make changes to any of the completed forms prior to final submission.

 

Faster Appointments
After your patient completes or updates a form on the kiosk, an alert is sent to your front office personnel. They can then review the forms and import the data directly into Dentrix, within seconds – no typing, no missing data and no delays. The efficient system allows the doctor to begin the treatment faster and the front office personnel to concentrate on other tasks.

Benefits:

  • Reduces the amount of time patients spend in the waiting room
  • Reduces compounding delays in the appointment schedule

 

Questionnaire Toast Message
An alert notifies the front office staff that the forms are complete and ready for review.

 

Easier Family Check–in
Ask any parent about the ease of completing patient forms while at the dentist office with children. Completing several forms for each child while trying to maintain order (or at least control chaos) can be a rigorous test of a parent’s patience. The patient kiosk shortens the time required to complete the forms and simplifies the process.

The intuitive software recognizes appointments for multiple family members, allowing the patient—a parent in this case—to update the records for each child without starting over each time. Forms can be completely finished before the children even reach the aquarium!

Benefits:

  • Improves the patient experience (for the parent and innocent bystanders)
  • Ensures that entire family files are up-to-date

 

Family Check-in
The family sign-in prompt allows a parent to complete forms for same-day family appointments without starting from the beginning.

 

Enhanced Professional Image
Patients want assurance that they’re receiving quality dental care. Part of achieving that level of comfort comes from knowing that their dentist uses the latest technology and techniques. Unfortunately, most patients don’t know enough about dentistry to tell the difference. Your colleagues will recognize your commitment to excellence in the simple fact that you’re a Dentrix practice; patients will not.

Patients are forced to make assumptions about the quality of dental care based on other observations in the office. Can the practice provide accurate out-of-pocket estimates? Does the practice have digital radiography? Is the dentist using a foot drill?

A kiosk provides further validation of the quality of your dental care in the minds of your patients. It shows that your practice is up on the latest trends and a leader in the industry.

Benefits:

  • Improves the overall patient experience
  • Improves patient loyalty and retention

 

Kiosk and eCentral
The new kiosk functionality is the perfect complement to the eCentral Web Site Manager’s online form completion process. Employing both functions allows patients to complete forms conveniently from home – prior to the appointment – or in your waiting area.

Getting Started
Getting a kiosk in your office is easy. If your practice is currently enrolled for the eCentral Web Site Manager, you’ll need to upgrade to the latest plan. New eCentral Web Site Manager customers will automatically receive the new kiosk functionality upon enrollment.

Call today to learn more about adding a kiosk to your practice. We’ll even explain all the hardware options, including those that include shipping and installation.

Say goodbye to the clipboard! Call 800-734-5561 today.

Visit our Kiosk page.

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Backing up Dentrix Image 4.5’s database

Backing up Dentrix Image 4.5’s database

This is a followup to the earlier post, Migrating Dentrix Image 4.5’s database to another computer. Please see that post to understand how I got here in the first place.

Now that we have successfully migrated, we want to begin the process of performing nightly backups of this data. As expected, Dentrix does not provide consistent, reliable documentation of how to do this, particularly for older platforms such as this. My goal here is to illustrate what I have done and solicit comments from others out there to understand their approach.
First, our setup.
  • Main Dentrix 11 and all DXImage files are running on Windows 2008 Server
  • DXImage database is running on Windows XP
  • We have a 2-disk RAID NAS in our network
  • We also subscribe to an offsite backup service, CrashPlan
We currently back up Dentrix Image’s database in two ways.
  1. With Dentrix’s internal backup. If you dig deep on the server where your image database is housed, you will see a folder called ViperDataBackup. In our case, this is in \Dentrix\DXImage\MSDE\MSSQL$VIPER\Backup\ViperData . This folder grows with two new files each day:
    ViperData_db_[date].BAK
    ViperData_tlog_[date].TRN
    These files seem to represent nightly backups. We use Cobian Backup on the server to copy all files from this directory to the NAS each night. The main issue, as illustrated below, is that I have no idea how to restore from these files currently.
  2. With our own scripts. DXImage database is running on Microsoft SQL Server Embedded, in a database called VIPER. We created a script that essentially backs up the VIPER database each night to a file, then copies that file to the NAS. The two main lines of this script are:
    osql -S SERVER2\VIPER -E -i SqlFullBackup.sql
    copy /Y /Z /V *.* X:\backup\
    where SqlFullBackup.sql is as follows:
    BACKUP LOG MASTER WITH TRUNCATE_ONLY
    BACKUP LOG MODEL WITH TRUNCATE_ONLY
    BACKUP LOG MSDB WITH TRUNCATE_ONLY
    BACKUP LOG VIPER WITH TRUNCATE_ONLY
    BACKUP DATABASE MASTER TO DISK =’C:\backup\MASTER-nightly-backup.bak’
    BACKUP DATABASE MODEL TO DISK =’C:\backup\MODEL-nightly-backup.bak’
    BACKUP DATABASE MSDB TO DISK =’C:\backup\MSDB-nightly-backup.bak’
    BACKUP DATABASE VIPER TO DISK =’C:\backup\VIPER-nightly-backup.bak’
    We then backup the entire contents of this c:\backup directory to the NAS.
We have not had the opportunity to test the restore procedure for this backup method. However, I feel fairly confident that, by backing up in two methods, we will be covered should disaster strike our poor little DXImage database. I particularly trust the second method, as it does not rely on having to contact Dentrix Image Support at all.

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Migrating Dentrix Image 4.5’s database

Migrating Dentrix Image 4.5’s database to another computer

This post is way off-topic for those who read me regularly, but it should be helpful for those looking for this information via a web search.

Our original server was a very old (1999ish), very slow Pentium running Windows XP Professional, Dentrix 11, and Dentrix Image 4.5.
We decided to upgrade, and bought a new Dell PowerEdge server with a Dual Core Intel Xeon processor and Windows Server 2008 64-bit edition.

Installing Dentrix, Image, and the other required applications went fairly smoothly, with only a possible hiccup with installing .NET Framework 1.1, required for Dentrix. I say possible because it was only a warning, and we don’t know if it will manifest into any problems down the road.

After installation came the hard part – moving the data.

  • Pulling the Dentrix data (ledger, chart, schedule, etc.; about 300MB) over was simply a matter of copying the data into the appropriate Data directory.
  • Pulling images (35GB) over took longer, given the amount of data, but it was as simple.
  • Figuring out how to transfer the Dentrix Image SQL Server database, the database that contains a mapping between patients and images, took an absurd amount of time.

I tried:

  • Stopping the SQL Servers on both source (old server) and destination (new server) and copying the .mdf/.ldf files from source to destination. This resulted in Chart showing “Cannot initialize image database”.
  • Using the seemingly-useful DXImage/bin/IDImage application, which ultimately failed.

The key to figuring out was this Microsoft Support article describing moving databases using sp_detach_db and sp_attach_db. To fix,

  • Open a command line on the source and type ‘osql -E -Q’ to get into SQL command line
  • Type:
use master
go
sp_detach_db 'Viper'
go
  • Copy ‘Dentrix\DXImage\MSDE\MSSQL$VIPER\Viper.mdf’ and ‘Dentrix\DXImage\MSDE\MSSQL$VIPER\Viper_log.ldf’ to the same location on the server as ‘Viper_2.mdf’ and ‘Viper_log_2.mdf’
  • Open a command line on the destination and type ‘osql -E -Q’ to get into SQL command line
  • Type:
use master
go
drop viper
go
sp_attach_db 'viper','C:\Dentrix\DXImage\MSDE\MSSQL$VIPER\Viper_2.mdf','C:\Dentrix\DXImage\MSDE\MSSQL$VIPER\Viper_log_2.ldf'
go
  • Make sure to change your firewall settings on your new server to enable SQL Server to access it.

This did it. Oh, how I wish Dentrix Image had better (or any, for that matter) documentation, except for this site which looks like it was written by someone in high school.

UPDATE: In all likelihood, the first method (copy .mdf and .ldf) might have worked had I tried changing the firewall settings sooner!

UPDATE 2: After a massive meltdown of our servers and a long technical session with the good people at Dentrix Image, we learned a few things:

  • Windows Server 2008 is NOT supported for Dentrix Image 4.5. It was practically sheer luck that enabled it to work. Windows XP and (I believe) Server 2003 are the only supported environments. The issue lies with the embedded Microsoft SQL Server used in Dentrix Image itself, which is incompatible with Server 2008.
  • However, since we already migrated Dentrix to Server 2008, and still had our workstations on XP, there is a solution: leave the actual images on our fast new Server 2008, and host the image database itself on a workstation running XP.
  • The caveat here is that both machines must be accessible by network names (e.g. “server1″, “server2″), and not just by IP address (e.g. “192.168.1.10”). So, if I ping “server1″, I would get a proper response. It is beyond the scope of this entry to explain how to make this work, but a hint to get you down that path: static IPs and the hosts file.

To get this hybrid system (image files on “dentrix server”, image database on “idb server”) to work:

  • Install Dentrix Image as a server install on a Windows XP machine. We’ll call this machine “idb server” below.
  • On the old server, run [DXImage]\bin\IDBAdmin
  • Choose Export Database and choose a path. Move the resulting exported database to the idb server.
  • On the idb server, run [DXImage]\bin\IDBAdmin
  • Choose Import Database and choose the file you just copied over.
  • Choose Initialize Database.
  • On the dentrix server, open [DXImage]\images\rtx.con . Change the file to point to the new server’s network name. This is the missing link: workstations will look at this file to figure out where to find the image database.

UPDATE 3: We have posted our backup process for the lowly Windows XP IDB Admin server in a follow-up, Backing up Dentrix Image 4.5’s database.

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Backing Up Your Dentrix G5 Database

Backing Up Your Dentrix G5 Database

Henry Schein is pleased to announce the release of Dentrix G5. G5 stores information in an SQL database, which significantly improves the speed of data access and overall performance and product stability.

Because of this new database structure, in Dentrix G5 the Dentrix database location has been moved to :\DENTRIX\Common. After installing Dentrix G5, you should configure your backup software to back up this new Common folder daily.

Important: If you are upgrading from a previous version of Dentrix, your old backup configuration will no longer be valid.

While it is important to back up all your important computer files, it is critical that you back up your important Dentrix database files in the Common folder, at minimum. Any data you choose to not back up cannot be restored in the event of data loss. For an in-depth look at the types of files contained in the Common folder, please see Backing Up the Dentrix G5 Database, available at www.dentrix.com/g5 under Installation Help.

You can update the files you want to back up by exporting a copy of your live database manually or by scheduling recurring exports to happen automatically with the Dentrix Server Administration Utility. The Dentrix Server Administration Utility is used to schedule an export of your Dentrix database.

Due to the nature of an SQL database, the Dentrix database server locks its database even when Dentrix is not open on any computer on your network (because the Dentrix ACEServer service is always running on the server). In order to back up the active database files, the database must be exported to a location where your backup software can back up a copy of your database.

To schedule a database export:

  1. Close all Dentrix modules on all computers on the network.
  2. On any computer, locate and double-click the executable for the Dentrix Server Administration Utility. The default location for the utility is C:\Program Files\Dentrix\_ServerAdmin.exe.

    Note: If you are using Windows Vista or Windows 7, the utility will be located at C:\Program Files (x86)\Dentrix\_ServerAdmin.exe
    Server Admin Location

  3. Click the Export/Restore Database tab to see Export/Restore options.
  4. Under Scheduled Database Exports, select Enable Scheduled Exports.

    Export/Restore Database Tab

  5. Set up the following options:
    1. Time – Enter the time you want the export to occur.
    2. Days – Select the checkboxes that correspond to the days of the week you want the export to occur.
  6. Click Update Scheduled Status to save the export schedule.

The export will start at the specified time on the selected days until you disable this feature. The length of time required to make a complete copy of your database depends on the size of the database (the number of patients, transactions, claims and so forth).

To learn more about how to back up your Dentrix G5 database, visit www.dentrix.com/g5, click the Installation Help link, and open Backing Up the Dentrix G5 Database.

If you have a current Customer Service Plan, you have 5 GB of free storage space available with eBackup. For more information about eBackup, please visit www.dentrix.com/products/eservices/ebackup.

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Dentrix Tools

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Dentrix Tips

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Sample Page

This is an example page. It’s different from a blog post because it will stay in one place and will show up in your site navigation (in most themes). Most people start with an About page that introduces them to potential site visitors. It might say something like this:

Hi there! I’m a bike messenger by day, aspiring actor by night, and this is my blog. I live in Los Angeles, have a great dog named Jack, and I like piña coladas. (And gettin’ caught in the rain.)

…or something like this:

The XYZ Doohickey Company was founded in 1971, and has been providing quality doohickeys to the public ever since. Located in Gotham City, XYZ employs over 2,000 people and does all kinds of awesome things for the Gotham community.

As a new WordPress user, you should go to your dashboard to delete this page and create new pages for your content. Have fun!

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>