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:

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 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.