Backup Access Data Store and Restore

While there is no built-in backup scheduler with Access, Presentation Server includes the DSMAINT BACKUP command for backing up Access Data Stores only. Citrix recommends that this command be executed daily using a scheduler script.
WARNING! Do not attempt to backup Microsoft SQL Server or Oracle databases using this command.
MDB: A file with the MDB file extension is a Microsoft Access Database file.
Moving / Restoring an Access Database
Access to a valid backup or Copy of the Data Store is assumed before the following procedure is started.
Moving an Access Database
To move an Access database, complete the following procedure:

1. Copy the Data Store file named “MF20.mdb” in the %system%\Program Files\Citrix\Independent Management Architecture\ folder from the source server to the target server, which will be the new Data Store host.
2. On the new host server, create a new File DSN by using the Microsoft ODBC manager pointing to the Data Store, as shown in the following screen shots:

3. Close the ODBC manager because you have created the required DSN file.
   The next task requires you to edit the registry settings.
   Caution! This fix requires you to edit the registry. Using Registry Editor incorrectly can cause serious problems that might require you to reinstall your operating system. Citrix cannot guarantee that problems resulting from the incorrect use of Registry Editor can be solved. Use Registry Editor at your own risk. Be sure to back up the registry before you edit it.


4. Run the Registry Editor and change the value of the following registry key from <blank> to ImaAccess.dll
   HKEY_LOCAL_MACHINE\SOFTWARE\Citrix\IMA\DatabaseDriver


5. Open a command prompt and run the following command to configure IMA and use the new DSN file.
   dsmaint config


6. is a sample for your reference:
   dsmaint config /user:citrix /pwd:citrix /dsn:<full path to the newly created DSN file from Step 2>.

Note: You can drag and drop the DSN file into the command prompt to avoid typing the wrong path.

6. Run the following command from the command prompt to stop the IMA Service and recreate the Local Host:
   dsmaint recreatelhc


7. On all the remaining servers in the farm, run the following command, where <DirectServername> is the name of the new host server.
   dsmaint failover <DirectServername>

Restoring an Access Database
It is assumed that the following tasks are completed before starting the procedure to restore an Access database:

• You have rebuilt or reinstalled XenApp to recover from a failure.
•  You have a working XenApp server up and running with IMA started.
• You have access to a backup copy of the old Access Data Base (MF20.mdb) created by the DSMAINT BACKUP command or some other method.

To restore an Access database, complete the following procedure:

1. Stop the IMA Service and copy the existing MF20.mdb file to a safe location.
   Note: You will be replacing this file with your backup MF20.mdb.


2. Copy the Data Store file named “MF20.mdb” from the backup source to the target server and save it in the %system%\Program Files\Citrix\Independent Management Architecture\ folder.
   Note: The IMA Service must be stopped before starting the next task.


3. Open a command prompt and run the dsmaint config command to configure IMA and use the existing MF20.dsn file.
   Following is a sample of the preceding command:

dsmaint config /user:citrix /pwd:citrix /dsn:<full path to the .dsn file >.

Note: You can drag and drop the DSN file into the command prompt to avoid typing the wrong path.

     4.    Run the following command from the command prompt to recreate the Local Host cache and any other servers in the farm so they are aware of the new information:
            dsmaint recreatelhc
            Note: Do not forget to stop IMA before you run the preceding command.