You are viewing limited content. For full access, please sign in.

Question

Question

Forms - View History by File Size so that I can free up enough space to run the 10.4 upgrade

asked on January 31, 2021 Show version history

I have a customer that ran out of database space with their express licensing plan. So we backed up their current data and deleted 3 years worth of data, leaving 2 years. The 3 years worth of data we deleted, 3000 instances, only released 50KB of data, not even enough to run the 10.3 to 10.4 upgrade script.

So given that I have already deleted 3 of the 5 years of data from the database and gained essentially no space. How do I see which instances are taking up the 10GB of total space?

0 0

Replies

replied on January 31, 2021

Hi Chad,

We've met several cases that database size will not be reduced until the database is shrunk. Please follow steps in https://docs.microsoft.com/en-us/sql/relational-databases/databases/shrink-a-database?view=sql-server-ver15

0 0
replied on February 1, 2021

Hi Ziyan

Shrinking a database is a way to clear up hard disk space, by freeing up disk allocated to free space inside of the database. In my case there is no free space inside of the database. This is my problem.

I need to free up space inside of the database by deleting history but I can not see what history is taking up the space.

0 0
replied on February 1, 2021

I eventually got to the data by just deleting everything up until late last year, the data was being taken up by a process they started late last year. It would be nice to see what is using your storage though, since otherwise all we can do is delete until we see space clear up.

After upgrading to 10.4.1 I will be able to tell the system to automatically clear up space, but this still does not mean it will be clearing up the largest files since it only acts on date ranges.

0 0
replied on February 1, 2021

In most cases, the attachments of instances occupies disk the most. Forms 10.4.4 has added an ability to store attachments in file system, so that the attachments can be stored outside database. On the other hand, volume management page is added along to show storage statistics of each process. I think this may help your case.

0 0
replied on February 2, 2021

Oh that is awesome, we can store files on the drive in real time? I will check this out. SQL storage space licensing costs are incredibly expensive compared with raw hard disk space.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.