Restoring Protected Data › How to Restore a Pervasive PSQL Database › Determine the Database and Location to Restore › Restore User Databases and System Databases to the Original Location

Restore User Databases and System Databases to the Original Location

During the restore process, you have the option of where you want to restore the database to. The available selections are Restore User Database to the Original Location, Restore User Databases and System Databases to the Original Location, and Restore User Database to an Alternate Location.

This procedure explains how to restore Pervasive PSQL user databases and system databases to the original location.

Follow these steps:

1. Access the Pervasive Control Center (PCC) from the operating system Start menu.

   Note: On Windows platforms, the Pervasive Control Center is installed by default when you install a database engine or a client.

2. Locate the databases from the Pervasive Control Center.
3. Delete the databases from the Pervasive Control Center.

   a. Right-click the database name.

   b. From the pop-up menu, select Delete.

   

   c. From the Delete Item dialog, select the option Yes, database name and ddfs.

   This option ensures the database files are deleted.

   

   d. Repeat for each database that needs to be deleted.

4. Stop the Pervasive PSQL Relational Engine service.
   1. Right-click Pervasive PSQL Relational Engine.
   2. From the pop-up menu, select Stop Service.

   

5. Delete all the database files (*.mdk, *.ddf) for the system databases such as DEFAULTDB, TEMPDB.

   By default the database files are located in "C:\ProgramData\Pervasive Software\PSQL\defaultdb" and "C:\ProgramData\Pervasive Software\PSQL\tempdb".

6. Delete the transaction log files in the log folder.

   By default the log folder is located in "C:\ ProgramData\Pervasive Software\PSQL\Transaction Logs".

7. Restore the whole Pervasive Software data folder to the original location by using the overwrite option.

   By default the folder path is "C:\ProgramData\Pervasive Software\PSQL".

   

8. From the Restore Options dialog, select Restore to original location and Overwrite existing files and click Next.

   

9. Restore the database files (*.mkd, *.ddf) to original location and overwrite the existing files.

   

10. Start the Pervasive PSQL Relational Engine service.
    1. Right-click Pervasive PSQL Relational Engine.
    2. From the pop-up menu, select Start Service.

The user databases and system databases are restored to the original location.