Making an MSDE Backup

You should make regular backups of your MSDE database in case of server failure.

To back up MSDE:

1. Shut down Aurea List Manager. If Aurea List Manager is running in a console window, ctrl-c begins the shutdown process. If it is running as a service, stop the service by navigating to Start -> Settings -> Control Panel -> Administrative Tools.
2. Shut down MSDE using the SQL Server Service Manager. It can be found by clicking Start -> Programs -> MSDE -> Service Manager.
3. Using Windows Explorer (Start –> Programs –> Accessories – Windows Explorer), In the left Navigation bar, click the SQL Server Data Directory:
   • C:\Program Files\Microsoft SQL Server\MSSQL\Data\ListManager_Data.MDF
   • C:\Program Files\Microsoft SQL Server\MSSQL\Data\ListManager_Log.LDF
   
   
4. Copy the entire data directory to your backup location.
5. Restart MSDE using the SQL Server Service Manager.
6. Restart Aurea List Manager.

To restore your backup

1. Stop Aurea List Manager.
2. Copy the ListManager_log.ldf and ListManager.mdf files from the backup location to the data directory of your MSDE installation.
3. Restart MSDE.