meta data for this page
  •  

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
vm:proxmox:kvm:windows:mssql [2025/01/08 20:13] – niziakvm:proxmox:kvm:windows:mssql [2025/01/09 08:37] (current) – niziak
Line 1: Line 1:
 ====== MS SQL ====== ====== MS SQL ======
  
 +===== move database files to optimized storage =====
 +
 +Recommended NTFS cluster size for MSSQL is 64kB. So ZFS's ''volblocksize'' also should be 64kB.
  
 Move MSSQL guest data files to dedicated VM disk. Move MSSQL guest data files to dedicated VM disk.
Line 18: Line 21:
 </code> </code>
  
-===== move database files =====+==== move database files ==== 
 + 
 +Info based on  
 +  * [[https://www.sqlshack.com/move-sql-database-files-mdf-ldf-another-location/|How to move SQL database files (MDF and LDF) to another location]] 
 +  * [[https://learn.microsoft.com/en-us/sql/relational-databases/databases/move-database-files?view=sql-server-ver16|Move database files]]
  
 <code sql> <code sql>