model_replicatedmaster.ldf move to another drive

Alen Cappelletti 686 Reputation points
2022-05-17T14:28:30.69+00:00

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.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,542 questions
No comments
{count} votes

Accepted answer
  1. CathyJi-MSFT 20,666 Reputation points Microsoft Employee
    2022-05-18T03:09:59.087+00:00

    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.


1 additional answer

Sort by: Most helpful
  1. Tom Phillips 17,511 Reputation points
    2022-05-17T18:47:51.21+00:00
    No comments