Question

How long before deleted instances are entirely removed from the Forms Database?

Forms Version 10

Updated June 22, 2016

asked on June 21, 2016 • Show version history

Customer is attempting to reduce the size of his Forms database.

Right now, the MDF file is around 93 GB. We upgraded to Forms 10.1 in order to reduce the size of the database by deleting older instances within Forms.

How long does it take for Forms to delete the instances entirely from database?

0 0

Answer

SELECTED ANSWER

replied on June 22, 2016

Side note: SQL will not automatically shrink the database when rows are removed. You can check its properties in SQL Management Studio to see how much free space it has (size vs space available) and shrink it manually.

1 0

Replies

replied on June 21, 2016

That depends on how many deleted instances you have in the database. You get the instances number by running following query on the database before upgrade to 10.1

SELECT COUNT(*) FROM [dbo].[cf_bp_main_instances] where status=99

0 0

replied on June 22, 2016 • Show version history

It already cleared the instances that were deleted in Forms 10.0 when it performed the upgrade process.

I am wondering how long before it initiates the query to delete or update the database after deleting an instance within Forms 10.1.

0 0

You are not allowed to follow up in this post.

Question

Question

How long before deleted instances are entirely removed from the Forms Database?

Answer

Replies

Sign in to reply to this post.