Many dentists across the United States are using Eaglesoft for their Dental Practice Management software solution. Careful consideration needs to be given when deciding on a backup strategy for this software.
The biggest problem is that Eaglesoft uses Sybase for its backend database and not SQL. What this means is that we can’t leverage standard Windows backup technologies, because Sybase isn’t VSS aware!
This means you need to take a couple of precautionary steps to ensure that your backup strategy meets your needs and addresses the complexities of Eaglesoft.
Step One: Prepare the Database for a Good Backup
Before you backup your Eaglesoft server, you need to ensure that the database engine is stopped. It is possible that at the end of the day, not all of your staff have disconnected their clients from the server. Simply modify the database engine settings to automatically disconnect all users when the Eaglesoft server is shutting down.
- On the Eaglesoft server, click on Start > Programs > Eaglesoft > Technical Reference.
- Click on Database Setup button
- Check Disconnect active clients when shutting down the server
Step Two: Automate the Database to Start and Stop Using Task Scheduler
We want the Eaglesoft database to stop before we take a backup. After our backup completes, we then want to start the Eaglesoft database.
Instead of performing these steps manually every day, we are going to use the Event Scheduler in Windows to perform these tasks for us.
Note that Patterson does not support this configuration, so you will need an experienced engineer to make sure that the tasks are created correctly and that the tasks complete successfully.
Add an Automated Task to Start the Database
- Click on Start > Control Panel > System and Maintenance > Administrative Tools > Task Scheduler
- Create a new task folder in the console tree called Eaglesoft Backup
- In the Actions pane, click on Create Basic Task
- Give the task the following name: “Eaglesoft Start Database”
- Under description, put “Automated task to start the Eaglesoft database after a backup of the server.”
- Set the event to start Daily
- Adjust the start time to a time of day after the backup will succeed. This could be 11:30 PM or later.
- Click on the Start a program radio button
- In the Program/script box input the following:
- For Eaglesoft 15 and below: “C:\Program Files\Eaglesoft\Shared Files\techaid.exe”
- For Eaglesoft 16 and above “C:\Eaglesoft\Shared Files\PattersonServerStatus.exe”
- In the Add arguments (optional) box put “-start”
- Click on the Next button
- Check the Open the Properties dialog for this task when I click Finish box
- Check the Run with highest privileges box
- OK button
- Provide administrative login credentials and click on OK
Add an Automated Task to Start the Database
-
Click on Start > Control Panel > System and Maintenance > Administrative Tools > Task Scheduler
- Create a new task folder in the console tree called Eaglesoft Backup
- In the Actions pane, click on Create Basic Task
- Give the task the following name: “Eaglesoft Start Database”
- Under description, put “Automated task to start the Eaglesoft database after a backup of the server.”
- Set the event to start Daily
- Adjust the start time to a time of day after the backup will succeed. This could be 11:30 PM or later.
- Click on the Start a program radio button
- In the Program/script box input the following:
- For Eaglesoft 15 and below: “C:\Program Files\Eaglesoft\Shared Files\techaid.exe”
- For Eaglesoft 16 and above “C:\Eaglesoft\Shared Files\PattersonServerStatus.exe”
- In the Add arguments (optional) box put “-stop”
- Click on the Next button
- Check the Open the Properties dialog for this task when I click Finish box
- Check the Run with highest privileges box
- Click the OK button
- Provide administrative login credentials and click on OK.
Step Three: Use an Image-based Backup Solution
The reason we recommend using an image-based backup solution is because you have more robust recovery options than if you were to just backup the Eaglesoft database, and your server crashed.
You server uses hardware like the motherboard, hard drive, and RAM to support an installed operating system. From within the operating system we have applications like Eaglesoft installed. The Eaglesoft application creates a database that only it is able to use.
When you use a File Backup Solution you only have backup data for the database. This means that if you were to have a hard drive failure, you would have to replace the hardware, then reinstall and configure your operating system. After you have reinstalled and configured your operating system, you then need to download, install, and configure Eaglesoft. Only after Eaglesoft is reinstalled and configured can you begin to restore your database from your file-based backup solution. This whole process could take days to complete.
When you use an image-based Backup Solution, you replace the hardware just like the file-based Solution. From there you can restore the operating system, Eaglesoft application, and database. The whole process can take as little as 15 minutes if you use the right backup software.
What Now?
We would love the chance to discuss your thoughts on backing up an Eaglesoft server. Let us know any alternative strategies that you have found useful. If there are any questions, put them in the comments below or give us a call and we are happy to help where we can.
Subscribe to our blog so you don’t miss out on amazing articles just like this!