Hi @YaroC ,
migrating SQL data to new storage...
Please reference the reply from this case: sql-database-migration-on-new-storage
Just not sure if their status as Unassigned really means that or are they somehow put together to form the Data volume?
You can check the Failover Cluster Manager to make sure whether the storage is assigned or not.
execute code as next:
use dbname
go
SELECT
current_storage_size_mb,
max_storage_size_mb,
actual_state_desc,
readonly_reason,
stale_query_threshold_days,
size_based_cleanup_mode_desc
FROM sys.database_query_store_options;
GO
More information: nodes-storage, check-sql-server-query-store-storage-utilization-with-tsql
Does it mean I'll have to create corresponding folders for temp and logs, move the content and delete the originals to correct the naming?
Yes. You need to firstly create the new file and then move data.
BR,
Mia
If the answer is helpful, please click "Accept Answer" and upvote it.