Making an MSDE Backup

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

To Backup MSDE

1. Shut down ListManager. If ListManager is running in a console window, ctrl-c will begin the shutdown process. If it is running as a service, stop the service by clicking on 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), navigate to the SQL Server Data Directory: Drive\MSSQL7\data\, where Drive corresponds to the Drive that you installed ListManager SQL on. In most cases Drive will be “c:\”.

4. Copy the entire data directory to your backup location.

5. Restart MSDE using the SQL Server Service Manager.

6. Restart ListManager.

Restoring ListManager MSDE databases

To restore your backup:

1. Stop ListManager.

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.