Power Monitoring Expert (PME): How to manually detach an ION Databases using SQL CMD commands in the command prompt.

Issue
The Power Monitoring Expert (PME) ION databases may need to be detached from the PME SQL instance. If there is an issue with detaching the databases using SQL Server Management Studio (SSMS).

Product line

Power Monitoring Expert 8.x
Power Monitoring Expert 9.x
Power Monitoring Expert 2020
Power Monitoring Expert 2021
Power Monitoring Expert 2022
Power Monitoring Expert 2023

Power Monitoring Expert 2024

Environment
Power Monitoring Expert (PME)

SQL Server
Command Prompt

Cause

Power Monitoring Expert (PME) databases may need to be detached for troubleshooting, upgrades, etc. The databases can be detached using SQL CMD commands from the command prompt if other methods are not successful.

Resolution

1. Open the command prompt (Type "cmd" in the Windows start menu) Note: After each command, press enter to execute.
2. Type one of the following commands to login to Microsoft SQL Server, replacing what's in the < > brackets with the correct system information. The first command is if using SQL Server Authentication for login, the second command is to use Windows Authentication to login.  (Example: sqlcmd -U sa -P ION!Everywhere -S MyServer\ION.)

   sqlcmd -U <username> -P <Password> -S <ServerName>\<SQLInstance>

   sqlcmd -E -S <WindowsDomain\Username> -S <ServerName\SQLInstance>

   
   
   
3. Next use this command to detach the database once again replacing < > with the correct system information. (Example: EXEC sp_detach_db ION_Data)

   EXEC sp_detach_db <database name>

4. Then type the following two commands:

> GO 
> QUIT

The database should now be detached.

Publié pour: Schneider Electric Belgium