Autogrowth option for Log File (Image files)

Radhai Krish 191

Data Migration Assistant (DMA) suggested below recommendation,

User's image

But the DB Properties don't have option for Autogrowth to ImageFiles

User's image

How to make it autogrow?

The DB is currently in CL100, soon to be upgraded to CL160

MikeyQiaoMSFT-0444 2,710 Reputation points

2024-09-10T03:23:46.56+00:00

Hi，Radhai Krish，We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

1 answer

MikeyQiaoMSFT-0444 2,710 Reputation points

2024-09-05T08:49:28.41+00:00

Hi，Radhai Krish

I think what DMA mentioned about autogrowth corresponds to the autogrowth of the database's log and data files. I would like to ask in what form are the image files stored in your DB?

For ease of management and performance optimization, for image files, one can usually opt for the FILESTREAM format.

Regards

Mikey Qiao

If you're satisfied with the answer, don't forget to "Accept it," as this will help others who have similar questions to yours.
Please sign in to rate this answer.
Radhai Krish 191 Reputation points

2024-09-05T11:19:45.5833333+00:00

Right - it is FILESTREAM data already - still DMA suggested to make autogrow option on.

And all the other files are already having the autogrowth option on except for this. How to achieve this?

Erland Sommarskog 110.3K Reputation points

2024-09-05T21:00:57.2366667+00:00

It does say in the screenshot above "Image_files does not use autogrowth option". And there is a simple reason for this: it is not applicable. Data and log files are that. Files. And files have a size. But the container for Filestream is a folder and a folder does not have a size per se, so there is nothing that can grow.

Of course, you can fill up the disk, but disks usually are not able to autogrow. :--)

Radhai Krish 191 Reputation points

2024-09-06T06:48:27.42+00:00

:) right.

So, I guess I can just ignore the DMA's suggestion for this?

MikeyQiaoMSFT-0444 2,710 Reputation points

2024-09-06T09:40:26.6233333+00:00

Radhai Krish，The advice from DMA is sometimes just for your reference and to help you troubleshoot potential issues during the upgrade. In this thread, DMA did not take the FILESTREAM feature into account, so continue with your upgrade.

If you are satisfied with the answer, don't forget to "Accept it," as this will help other friends who have similar problems.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Autogrowth option for Log File (Image files)

1 answer

Your answer