Changing Data Drive Allocation Unit Size on Existing Installation

• garyb1

  SSC Enthusiast

  Points: 174

  More actions

  April 22, 2021 at 12:43 am

  #3874122

  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.

   

   

   

   

   

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  April 23, 2021 at 1:10 am

  #3874606

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

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