Before running the SQL query below on the active Archive database, make sure you have a current backup of the Active Administrator databases.
- Restart the Active Administrator foundation service to terminate the archive task if it is hung.
- Open SQL Server Management Studio.
- Expand Databases.
- Right click the active archive database for Active Administrator and select "New Query".
- Execute the SQL query below:
Delete tblDistinctProperty
Run the archive task to confirm the issue is resolved.
The information in the script(s) provided is known to work successfully; however, they have not been officially tested by Quest Software Quality Control. If any of these instructions are changed and/or incorrectly used, intentionally or unintentionally, this solution becomes unsupported by Quest Software Support and Development.
Quest Software Support and Development recommend always making a backup of the current database prior to execution of any script(s) that may modify it.
