Database Maintenance Plan Recommendations, Performance Tuning, System Configuration, and Antivirus Scan Settings

The data in your Dentrix Enterprise database is one of your most valuable resources used in managing your dental business. Dentrix Enterprise customers are responsible for maintaining their database and for ensuring that they have an adequate disaster recovery plan. To accomplish this, you will need trained personnel and the equipment necessary to support your database and be able to implement your disaster recovery plan.

Important: In order to protect your investment, a disaster recovery plan needs to be developed, implemented, maintained, and tested.

Legal Disclaimer: Henry Schein One makes no representations or warranties with respect to the contents or use thereof. Dentrix Enterprise Customers are responsible for maintaining their own database and for ensuring they have an adequate plan, trained personnel, and the equipment needed to support their database and to be able to recover from a disaster. All contents are subject to change.

Standard recommendations

Click any of the following links to learn about general maintenance items that you should review with your database administrator (DBA) to create a plan to protect and secure your database server and data. Your plan may need to be customized to fit your needs and your environment.

Certified database administrator

MS SQL Server documentation

Detailed recommendations

Click any of the following links to learn about concepts, features, and detailed instructions for maintaining your database.

Having a backup and restore plan for all databases

Creating MS SQL maintenance plans

Assigning a password for the MS SQL Server Administrative (SA) user

Creating a full database backup for key events

Backing up transaction logs

Backing up the live database every day

Checking server hard drive space

Storing database backups off site

Compressing and defragmenting databases

Monitoring database performance statistics

Monitoring storage capacity (IHS facilities only)

Maintaining and tuning database indexes

Rebuilding database indexes

Installing patches for the operating system and MS SQL Server

Evaluating server hardware

Configuring antivirus software