Power Monitoring Expert - SQL script to truncate a table in ION_Data Database
Issue
A SQL script is needed to delete "ALL" historical data from the ION_Data database faster.
Product Line
Power Monitoring Expert 7.x
Power Monitoring Expert 8.x
Power Monitoring Expert 9.x
Power Monitoring Expert 2020
Environment
SQL Server Management Studio
Cause
The "Truncate" query is a faster way to remove all data from specific tables that holds historical data. Truncate is faster and uses fewer system resources than a regular trim job.
Note: Truncate removes "ALL" entries from a table once it is executed.
Resolution
*Warning: Irreparable database damage can occur. Databases should be backed up prior to performing this procedure.*
*Warning: This procedure is recommended to be deployed by users familiar with Databases.*
The following are the scripts to remove "ALL" entries from DataLog2, EventLog2, and WaveformLog2 respectively.
1-
USE ION_Data
TRUNCATE TABLE DataLog2
2-
USE ION_Data
TRUNCATE TABLE EventLog2
3-
USE ION_Data
TRUNCATE TABLE WaveformLog2
A SQL script is needed to delete "ALL" historical data from the ION_Data database faster.
Product Line
Power Monitoring Expert 7.x
Power Monitoring Expert 8.x
Power Monitoring Expert 9.x
Power Monitoring Expert 2020
Environment
SQL Server Management Studio
Cause
The "Truncate" query is a faster way to remove all data from specific tables that holds historical data. Truncate is faster and uses fewer system resources than a regular trim job.
Note: Truncate removes "ALL" entries from a table once it is executed.
Resolution
*Warning: Irreparable database damage can occur. Databases should be backed up prior to performing this procedure.*
*Warning: This procedure is recommended to be deployed by users familiar with Databases.*
The following are the scripts to remove "ALL" entries from DataLog2, EventLog2, and WaveformLog2 respectively.
1-
USE ION_Data
TRUNCATE TABLE DataLog2
2-
USE ION_Data
TRUNCATE TABLE EventLog2
3-
USE ION_Data
TRUNCATE TABLE WaveformLog2
게시 대상: 슈나이더 일렉트릭 Korea
도움이 필요하신가요?
제품 선택기
애플리케이션에 적합한 제품과 액세서리를 빠르고 쉽게 찾을 수 있습니다.
견적 받기
영업 관련하여 온라인으로 문의하시면 전문가가 연락드립니다.
구매처
해당 지역의 가장 가까운 슈나이더 일렉트릭 대리점을 쉽게 찾을 수 있습니다.
지원 센터
한 곳에서 모든 요구 사항에 대한 지원 리소스를 찾아보십시오.