Issue
​A Power Monitoring Expert (PME) database may need to be moved to another drive especially if one drive is full.

Product Line
ION Enterprise 5.0/5.5/5.6/6.0
StruxureWare Power Monitoring 7.0.x
Power Monitoring Expert 7.2.x
Power Monitoring Expert 8.x
Power Monitoring Expert 9.0
Power Monitoring Expert 2020
Power Monitoring Expert 2021
Power Monitoring Expert 2022
Power Monitoring Expert 2023

Environment
SQL Server Management Studio

Resolution
*Warning: Irreparable database damage can occur. This procedure should only be performed by users familiar with SQL Server Management Studio. Databases should be backed up prior to performing this procedure.*

Use the following steps to move the databases to the new location.This procedure is applicable to both standalone and distributed installations.

1. Take backups of the database(s) that need to be moved
   1. Open SQL Server Management Studio
   2. Right-click on the database that needs to be moved, select 'Back Up...' under 'Tasks'
   3. Inside the Back Up Database window under General confirm the Back up Destination is set to Disk and then select 'Add…'
   4. Finally, provide a location for the backup and add the name of the back such as 'ION_Data230124.bak'
2. Stop all ION Services:
   1. Open Control Panel
   2. Select Administrative Tools
   3. Select Services
   4. Right-click on the service and choose stop.  All PME services start with ION as of PME 9.0.  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.
   5. Services will no longer say Running under the status column once they are stopped.

3. Detach the database(s).
   1. Open SQL Server Management Studio
   2. Right-click on the database that needs to be moved, select 'Detach...' under 'Tasks'
   3. From the Detach Database screen select 'Drop Connections' and press 'OK'
   4. Repeat steps a-c for any other database that needs to be detached.
4. Restore the database backup:
   1. Open SQL Server Management Studio
   2. Right-click the Databases folder > Restore Database
   3. In the Restore Database window select Device and click the right-hand box labeled '...' to select the desired backup instance
   4. Click 'Add' and navigate to the location of the .bak file, then select 'OK'
   5. The Restore Database window should then be populated similarly to the image below.
   6. In the 'Select a page' menu on the left choose the 'Files' option
   7. Inside the Files page check 'Relocate all files to folder' and choose the desired location of the .mdf and .ldf
   8. Select 'OK' to restore the backup.
5. Start the ION Services.
   1. Go to Control Panel > Administrative Tools > Services
   2. Right Click the automatic services and any others that are normally used and chosen start.
6. Change the scheduled backups and archives to point to a new location by following FA23057

Publié pour:Schneider Electric Belgium