Technical FAQs

Ask a Question

Moving ION Databases to Another Drive on the Same Server.

​In some cases the databases may need to be moved to another drive especially if one drive is full. Use the following procedure.

Product Line 
ION Enterprise 5.0/5.5/5.6/6.0, SPM 7.0.1, PME 7.2.2, PME8


1) Stop all ION Services.  (Control Panel > Administrative Tools > Services)

  • a) Right click on the service and choose stop.  All the software's services start with ION or Application modules.  It is best to start with the ION Network Router Service and choose yes when it asks if you would also like to stop its dependencies.
  • b) Services will no longer say started under the status column if they are stopped.

2) Detach the ION databases.

  • a) Open Management Console
  • b) Go to Tools > Database Manager
  • c) Expand down to ION_Data as shown in the screen shot.

  • d) Click on Detach on the right.
  • e) Repeat steps a-d for the ION_SystemLog ION_Network databases and Application modules( if applicable).

3) Move the ION databases to a new location on the server.
  • a) The default location of the databases is install_dir…\Power Monitoring Expert\Database.
  • b) Click on the Data folder in this location and ION_Data.mdf and ION_Data_log.LDF can be seen.  These are the ION_Data databases.
  • c) Copy the ION_Data.mdf and ION_Data_log.LDF files.
  • d) Paste these files in the new location on the other drive.
  • e) Repeat this procedure for the ION_Network, ION_Systemlog  and application modules databases.  These .mdf and .ldf files can be found in the Network and Systemlog folders found in the …\Power Monitoring Expert\Database folder.
4) Attach the ION databases.
  • a) Open Management Console
  • b) Go to Tools > Database Manager
  • c) Right click on Databases.
  • d) click on attach.
  • e) Browse to the ION_Data database on the new drive and open the ION_Data.mdf file.
  • f) Attach as: ION_Data and click ok.
  • g) A message saying it was successful should appear, click ok.
  • h) Repeat these steps for the ION_Network.mdf, ION_Systemlog.mdf files and Application_Modules.mdf.  Attach as: ION_Network and ION_Systemlog respectively.

5) Move the archives to a new location.
  • a) In the database manager, right click on the databases folder, go to all tasks, and choose show archives.  (All archives will be blue). In PME 7.2 and newer versions, check the box at the right side to show the archives.
  • b) Detach all the archives, copy them to the new server, and reattach the archives the same way that we did for the ION databases.  The default location for archives is …\IONEnterprise\config\cfg\Archives\Data.  Attach the databases as the archive file name without the .mdf.
6) Move the backups to the new location.
  • a) Backups are not attached so there will be no need to detach and attach these.  The default location of database backups is …\Power Monitoring Expert\config\cfg\DBBackups
  • b) Copy all of the backups that are in the Data and Network folders and paste them on the new drive.  Database backup files have a file extension of .bak.
7) Start the ION Services.
  • a) Go to Control Panel > Administrative Tools > Services
  • b) Right Click the automatic services and any others that are normally used and choose start.

8) Change the scheduled backups and archives to point to the new location( for SPM 7.0.1 and below)

  • a) In Database Manager expand down to Schedules.
  • b) On the right, right click on the first job and choose the edit option.
  • c) Change the location of the backup to the new location in Save backup to:
  • d) Repeat this for each ION_Data and ION_Network backup and archive job.  This will not be necessary for ION_Systemlog or any of the maintenance jobs.  ION_Network will not have an archive job.
  • e) Click ok.
  • f) For PME7.2 and above, the task scheduler is responsible for backup and archives. To reconfigure the task scheduler's location, click here
Was this helpful?
What can we do to improve the information ?