Carl Stalhood

Monday 25 March 2013

How to Backup or Move an Access Data Sore to a new Host Server

Use this procedure to install a backup of the data store or move an original data store to a new host server in the event of a hardware failure or upgrade:

1. Stop the IMA Service on Both the old host server and the new server host server.

2. Copy the backup database or the original database (mf20.mdb) to the new host server.

If you copy the back file there is the need to rename it after the copy, save yourself 5 seconds and copy the original.

3. Start the IMA Service on both servers

4. On the new host server, create a new DSN file (MF20.dsn) that points to the new localdatabase (mf20.mdb) from Step 2.

q On all servers in the farm (except the new host server), execute dsmaint failover new-host-server.

The IMA service must be running on these servers for the command to execute properly.

q On the new host server, execute dsmaint config /user:citrix /pwd:citrix /dsn:"M:\Progra Files\Citrix\Independent Management Architecture\MF20.dsn" (this points the IMA service to the newly created DSN file from Step 4.

Give the full path as show above or the procedure will fail

If security was set on the Access database, use the new user account and password information (default information is user=citrix & password=citrix).

q Change the original host server to its new role as an indirect server (it will now access the data store indirectly through the new host server) by running the Registry Editor (Regedt32.exe) and changing the value of the following registry key from Imaaccess.dll to Imaodbc.dll. HKEY_LOCAL_MACHINE\SOFTWARE\Citrix\IMA\DatabaseDriver

5. Stop and restart the IMA service on all farm servers.

6. When the IMA service on the new host server is running, stop and restart the IMA service on all of the other servers in the farm

No comments:

Post a Comment