We assume that you already know how to make a full backup of Data Manager and made one. If not, check the FAQ item: How to make a full backup of Data Manager and follow the steps.
Restore database from a full backupLet's start with restoring the databases. It will be explained once, but you will have to execute these steps for each database.
- Stop all DM applications and services. The services can be stopped by going to Start > S4M Data Manager > S4M-DM-StopServices.
- Delete existing DM databases (usually called ETL, ETL_Data and GenericWS). You can delete databases by right-clicking on them and click on Delete.
Figure 1: Deleting databases
- Click on OK on the popup to start the deletion process.
- Next, right-click on the folder Databases and select Restore Database.
Figure 2: Restore database
- The following screen will popup:
- Select Device as a source and click the button with the three dots to open the Select backup devices window.
- Click on the Add button.
- A new popup will open with a folder and file selector. Locate the backup of the database that you want to restore, select it and click on OK. In the case of this tutorial, we need to restore the database called ETL510.
- Click OK.
- You will see that a record is added to the Restore plan list. Make sure the checkbox under Restore is checked.
- Give the right database name in the Destination Database textbox.
- Click on Options in the left pane of the Restore Database window.
- To make sure the database is written correctly, select the checkbox Overwrite the existing database (WITH REPLACE).
- Click OK to start the restore process.
Restore fileset from full backupRestoring the fileset is the easiest step in the restoring process.
- Again, make sure that no DM Applications or DM services are running before continuing.
- Locate the backed up fileset and extract it. (We recommend not to extract and replace at the same time, so extract to a folder that doesn't exist yet. You can delete the folder after the fileset is restored.)
- Then copy the S4M_DM folder and paste it to the place where DM is installed (The default location is C:\). When asked to replace the files, agree with replacing.