Changing Data Drive Allocation Unit Size on Existing Installation

  • I have an existing SQL Server 2019 Standard installation that includes SSRS. The setup is fairly typical and the databases are relatively small at this point. There is a C drive and two additional local drives; one for data files and one for backups. The data drive was formatted for 4K and I'd like to change this to 64K as recommended. My question for the experts-- would the following steps work to correct this, or are there additional complications with this approach? Thanks.

    1. Turn off SQL services.

    2. Copy contents of data drive to another local drive.

    3. Format the data drive to 64K

    4. Move the content back to the data drive.

    5. Restart SQL services.

     

     

     

     

     

  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply