model_replicatedmaster.ldf move to another drive

Question

Hi all,
I'm curios about this 2 new DB (system).
I'm moving all ".ldf" file to a single drive... but they are related (seems to me) to HA.

I read this post
https://stackoverflow.com/questions/60971100/sql2019-with-sqlengine-installation-4-new-system-files-are-showing-but-no-new-sy

but I did not understand if it is possible to move them and how? Or is it a no sense?

model_msdblog.ldf
model_msdbdata.mdf
model_replicatedmaster.mdf
model_replicatedmaster.ldf

Thanks in advice, Alen.

Answer 1

Hi @Alen Cappelletti ,

When you deploy SQL Server Big Data Cluster with high availability, all databases are automatically added to the availability group, including all user and system databases like master and msdb. This capability provides a single-system view across the availability group replicas. Additional model databases - model_replicatedmaster and model_msdb - are used to seed the replicated portion of the system databases. Refer to MS document Deploy SQL Server Big Data Cluster with high availability.

> but I did not understand if it is possible to move them and how? Or is it a no sense?

I did not find any MS document talking about this. Quote from this thread that you offered;

You simply cannot copy and paste the db files to a different location when sql has a handle on it.

Answer 2

Those files are only used by "Big Data Cluster" installations.

See:
https://learn.microsoft.com/en-us/sql/big-data-cluster/deployment-high-availability?view=sql-server-ver15