Congratulations, you've taken on the role of SQL Server production DBA! :) More seriously, your question relates to standard SQL Server practices; you're going to have to learn something about database administration to manage your data and keep it safe.
You're right that the server doesn't back itself up automatically. Even the manual backup feature only backs up the shares, and by default your database is probably not stored in the shares, so Windows Home Server backups won't help you. In addition, most
backup tools have trouble with files that are in use at the time of a backup. Some skip the file entirely, some will back up the state of the file as of the last time it was written to disk. So just backing up files isn't sufficient; you need to make sure
that transactions are flushed to disk prior to backups, or you need to use a tool which can back up an active database.
For information about how to back up your BCM data in a standard Outlook configuration, you might want to start
here . For information about restoring, look
here . And for more information about how Microsoft intends you to share BCM data, start
here .
Note that what you've probably done is install SQL Server Express on your server; it's hard to give specifics on backing up your data in your new configuration, both because the installation of SQL Server, SQL Server Express, Business Contact Manager, etc.
is unsupported on Windows Home Server for end users, and because this is a Windows Home Server support forum, not a SQL Server support forum.
I really think your best bet is to ask some questions of whoever it was that created the video you used as a model.
I'm not on the WHS team, I just post a lot. :)
