How to manually detach an ION Database using OSQL commands in the command prompt.
Issue:
An ION database cannot be detached using ION Database Manager or 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)
Microsoft SQL Server
Command Prompt
Cause:
The database is locked or cannot be detached using standard tools.
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.*
If the database cannot be detached using Database Manager or SSMS, it can be detached using SQL command-line tools.
1. Stop PME services to release database connections.
2. Open a Command Prompt.
3. Connect to SQL Server using:
sqlcmd -U <username> -P <password> -S <ServerName>\<Instance>
Example:
sqlcmd -U sa -P ION!Everywhere -S MyServer\ION
4. Set the database to single user (required if connections exist):
ALTER DATABASE [ION_Data] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
5. Detach the database:
EXEC sp_detach_db 'ION_Data'
6. Execute the command:
GO
7. Exit:
QUIT
The database should now be detached.
Note:
The OSQL utility is deprecated and may be removed in future versions of Microsoft SQL Server. It is recommended to use SQLCMD instead.
For instructions on using SQLCMD to detach PME databases, refer to FAQ000281738.
Recommendation:
If you are using an older version of PME, consider upgrading to the latest version for improved protocol support and security. For assistance with integration or upgrades, contact Schneider Electric Technical Support at: pmo.support@se.com