What would be the optimal allocation size for a backup disk for SQL Server? We have a 2014 instance which was using Veeam backups till recently, but we decided to switch to local backups again for some reasons. Does the 64k size hold good for backups as well? Please advice
Sql-server – Allocation Size for Backup disk on SQL Server
backupconfigurationsql serverstorage
Related Question
- SQL Server 2008 R2 – Backup Compression Features
- Sql-server – SQL server compress backup for lower version databases
- SQL Server Backup to Local and Mirror to Azure Files – Error Resolution
- SQL Server – Investigating Causes of Unstable Backup Size
- Sql-server – Configuring backup drives for Alwayson
- SQL Server – Backup to Azure Blob with Different Plan Than Local Backup
- SQL Server 2017 – Instance Root Directory on 64k Allocation Unit Size
Best Answer
Backups are written sequentially, and as such they are far less sensitive to allocation unit and sector sizes.
64K should be no problem at all.