My wife's business uses a piece of client/server software called "Encompass", by the company "Ellie Mae".

I just got off of their tech support line. I asked them how to back up the server's data, and they said they don't support that. WHAT?

What they mean is, they can tell us what needs to be backed up, but not HOW to do it. Because they don't want to be held responsible for our data going south.

Anyhoo, one of the things that needs to get backed up is the SQL database. Their software installs MSDE (Microsoft Database Engine, which is essentially SQL Lite), and their database within MSDE is called "EMMSDE" (Ellie Mae MSDE). Their installation doesn't include tools such as the SQL Enterprise Manager, which is what I'd normally use to back up the data.

There are a lot of cryptic script commands that I could use with MSDE to back it up, but I'm wondering if it's much simpler than that.

There is a folder...

\Program Files\Microsoft SQL Server\MSSQL$EMMSDE\Data

...which looks like it contains the data I want. If I stop the MSSQL$EMMSDE service, back up that folder, then restart the service, does that mean I've successfully backed it up? And if so, is restoration a similar procedure?
_________________________
Tony Fabris