Issue with Database Shrinking – External database.
Issue Description – User facing delayed responses in PAM.
Cause – This issue occurs when the database size is occupied with the database logs, which in result causes delay for the end users.
Resolution – This issue gets resolved by shrinking the database using the below steps.
Run the SSMS application.
Click on the connect button àSelect Server Name from the dropdown à Select the Authentication type as SQL Server Authentication.
Enter the credentials for the sectonadb (credentials are mostly Username – spectradbadmin and the default password).
In the left side panel click on the button of the connected server to drop down the further options.
Click on the button of the Databases option.
Select the PAM database (SectonaDB) and right click on it.
Click on the Tasks option àclick on the Shrink option à Select the Files option.
In the Shrink file window, select Log option in the File type.
Click on ok the execute the task.