Backing up Repironics database

khvn · Post by **khvn** » Sun Dec 30, 2007 6:26 pm

I'd like to back up the accumulating data in my Respironics database so far. Does anyone know the names of the files that make up this database? Thanks!

jsmythe · Post by **jsmythe** » Sun Dec 30, 2007 6:34 pm

Go to:

http://www.mycpap.org/ and download the Tool kit...

6PtStar · Post by **6PtStar** » Sun Dec 30, 2007 7:15 pm

What Joyce said if you want to back-up the card. If you want to back up the SQL data base use the export patient option in Encore Pro. If you are trying to back up the data base in Encore Viewer someone else will have to help.

Export patient will not remove it just make a copy.

Jerry

sburke91 · Post by **sburke91** » Sun Dec 30, 2007 7:51 pm

If you're comfortable 'under the hood', so to speak, you can also download and install the SQL Express management studio, and use it to back up the entire Encore Pro SQL database:

http://www.microsoft.com/downloads/deta ... laylang=en

khvn · Post by **khvn** » Mon Dec 31, 2007 12:27 am

Thank you, folks.

I think I've located the Encore Pro database files I'm looking for. They are in this folder: "C:\Program Files\Microsoft SQL Server\MSSQL$ENCOREPRO\Data".

In this folder, there are a bunch of files. Of these, the EncorePro.mdf is the master database file so, definitely, it's the biggie file we'll need. But how about the others? Maybe couple more supporting files are also needed?

I'm sure some computer expert in here can readily point out to us the complete set of files that need to be included in the backup set.

The beauty of having full control of these files is that:

(1) You can back them up and retain all the data you have ever downloaded from your card through out the years (is there a limit to their sizes? Again, some computer expert will tell us?)

(2) You can transplant all your data to any computer you want. This is particularly useful when you have a new computer and you want to move your data to that new computer.

wolftracker · Post by **wolftracker** » Mon Dec 31, 2007 4:56 am

hi,

export patient pretty much does the same thing
you export the file ...

and it can be read into the encore pro installed on different
machines ...

it is real easy and it gives you all the data you have input

you dont have to worry about all the other files either

my .02
wolf

sburke91 · Post by **sburke91** » Mon Dec 31, 2007 5:36 am

khvn wrote: I think I've located the Encore Pro database files I'm looking for. They are in this folder: "C:\Program Files\Microsoft SQL Server\MSSQL$ENCOREPRO\Data".

In this folder, there are a bunch of files. Of these, the EncorePro.mdf is the master database file so, definitely, it's the biggie file we'll need. But how about the others? Maybe couple more supporting files are also needed?

The one downside to this method is that unless you stop the SQL server service on your computer before you make copies of these files, you can potentially end up with 'backups' that are just about worthless, as they won't mount to a new installation on another machine.

Encore Pro installs the 'light' version of Microsoft SQL server, which is an enterprise-grade relational database server. For the non-computer savvy, it's basically a separate program from Encore Pro, and Encore Pro 'talks' to it to. However, once it's installed, it's always running, and does things 'under the hood' to maintain the database.

Encore Pro's designed so a DME, or other provider, can have multiple workstations accessing and manipulating the same set of patient(s) data at once, thus the reason for SQL Express (or MSDE at it appears the pre 1.8 versions use).

If you're not technically savvy, the 'export patient' fucntion from within Encore Pro is going to be your safest backup option.

This discussion really makes me wonder how many providers are actually doing good backups of their Encore Pro data, as we all know how technically savvy most healthcare providers are

dllfo · Post by **dllfo** » Tue Jan 01, 2008 4:33 am

Are you wanting to download the data just for reference or to another computer so you have your data in two places?

I think I did the same thing as you are talking about when I went to Program Files, Respironics, and copied all the files, not just data. I only wanted the data for reference or emergency type usage.

Please let us know how it turns out.

Guest · Post by **Guest** » Tue Jan 01, 2008 2:31 pm

dllfo, I'd like to get a hold of my Encore Pro database for 2 reasons:

(1) Backup: My sleep data have been accumulating in my Encore Pro database all this time and I don't want to loose everything when my hard drive crashes (which is only a matter of time).

(2) Trans-planting: I'd like to be able to move my database to another hard drive on another computer if needed. And yes, you can keep your sleep data on more than one computer if you choose to.

To do both (1) & (2) above, all we need is to backup/copy all the 10 files found under the "C:\Program Files\Microsoft SQL Server\MSSQL$ENCOREPRO\Data" folder.

One snag here though, I got this error "file being used by other programs" when I tried to copy the database. sburke91, in couple of posts back, has mentioned something about SQL processes running in the background. I think those processes are having a lock on the database and that causes the copy error. So, until some computer expert here tells us how to stop these SQL processes...

Once those processes are stopped, we'll get to capture the complete Encore Pro database and store/move them anywhere we see fit.

jskinner · Post by **jskinner** » Tue Jan 01, 2008 3:34 pm

khvn wrote:I'm sure some computer expert in here can readily point out to us the complete set of files that need to be included in the backup set.

I highly recommend that you use the patient export function of Encore Pro rather than messing with the database files directly.

GumbyCT · Post by **GumbyCT** » Tue Jan 01, 2008 5:18 pm

jskinner wrote:
khvn wrote:I'm sure some computer expert in here can readily point out to us the complete set of files that need to be included in the backup set.
I highly recommend that you use the patient export function of Encore Pro rather than messing with the database files directly.

I have wondered why no one will talk about this - Care to share why -

Why use the export function rather than copy which is sooo much faster? Seriously??

sburke91 · Post by **sburke91** » Tue Jan 01, 2008 5:24 pm

GumbyCT wrote:
Why use the export function rather than copy which is sooo much faster? Seriously??

See my post about 4 up--there's some detail in what goes on behind the scenes with encore pro.

While I'm new to the whole xPAP world, I've been an IT guy for the past 12 years, and have spent more time than I'd like to admit dealing with databases here and there.

jskinner · Post by **jskinner** » Tue Jan 01, 2008 6:23 pm

GumbyCT wrote:Why use the export function rather than copy which is sooo much faster? Seriously??

Unless you really know what you are doing its much safer. Plus it allows you to backup from one version of EP and restore to a newer version.

Machine	Mask

Additional Comments: Armini about every other week for travel.