Job Management Partner 1/Software Distribution Setup Guide

[Contents][Glossary][Index][Back][Next]

Appendix F.11 SwitchPartition.sql query script

USE [NETMDM_SAMPLE]
GO
 
ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 1 TO netmdm_monitoring_security_arch PARTITION 1
GO
 
ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 2 TO netmdm_monitoring_security_arch PARTITION 2
GO
 
ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 3 TO netmdm_monitoring_security_arch PARTITION 3
GO
 
ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 4 TO netmdm_monitoring_security_arch PARTITION 4
GO