Can I delete distmdl.mdf & distmdl.ldf ?

My I delete distmdl.* ?
This files are for what ?
Apparently are not required for SQL to start.
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

These are for replication.  If you plan to never use sql replications services, you can safely delete them.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
migavAuthor Commented:
I moved distmdl.* out system folder and I manged to configure replication on that server.
More in detail distmdl are for what ?
They are the default model databases for replication as model is for standard databases.
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

migavAuthor Commented:
How to customize the distmdl ?
Partially. It holds the default settings for replication.  You can change it like changing the model database to change the way a database is configured anytime you add a new one.
migavAuthor Commented:
This database is not connected, how do I change the default settings  for replication ?
A system database that is stored on the Distributor server. The distribution database does not contain any user tables; it is used by the replication components of SQL Server, to store data including transactions, snapshot jobs, synchronization status, and replication history information.
migavAuthor Commented:
Hello GKalosky:,
Thanks for your very fast answers.
I ask your help to clarify de role of distmdl.
As you explanied "(..) It holds the default settings for replication.  You can change it like changing the model database to change the way a database is configured anytime you add a new one."
The question is how to change distmdl since it is not connected ?
Anthony PerkinsCommented:
Award point to the following comments as they accurately answered the original question:
Following an 'Objection' by acperkins (at to the intended closure of this question, it has been reviewed by at least one Moderator and is being closed as recommended by the Expert.
At this point I am going to re-start the auto-close procedure.
Thank you,
Community Support Moderator
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.