Autogrowth option for Log File (Image files)

Question

Data Migration Assistant (DMA) suggested below recommendation,

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

How to make it autogrow?

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

Answer 1

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. :--)

Answer 2

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.

Answer 3

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.