meta data for this page
  •  

Differences

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

Link to this comparison view

Next revision		Previous revision
vm:proxmox:kvm:windows:mssql [2025/01/08 19:56] – created 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>
Line 28: Line 35:
 GO GO
 </code> </code>
 +
 +<code sql>
 +ALTER DATABASE MY_DATABASE SET OFFLINE;
 +GO
 +</code>
 +
 +Stop MSSQL service.
 +
 +Give new location rights for MSSQL service user (check what user is set in services).
 +
 +Move database files to new location.
 +
 +Start MSSQL service.