Manually archiving through SQL when the Database Maintenance Utility is not working, or when you would prefer to archive through SQL.
Procedure Steps
- Log into SQL Server Management Studio.
- Expand Databases.
- Expand the SecurePerfectHistory database.
- Expand Programmability.
- Expand Stored Procedures.
- Right-click on BackupData and select Execute Stored Procedure. This procedure moves data from history to the archive.
- After the query completes, right-click on the SecurePerfectHistory database and select Tasks > Shrink > Database. This shrinks the history database to the correct size.
Applies To
FCWnx
SQL
