Can I delete distmdl.mdf & distmdl.ldf ?

My I delete distmdl.* ?
This files are for what ?
Apparently are not required for SQL to start.
migavAsked:
Who is Participating?
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.

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

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:
Hello,
I moved distmdl.* out system folder and I manged to configure replication on that server.
More in detail distmdl are for what ?
 
0
GKaloskyCommented:
They are the default model databases for replication as model is for standard databases.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

migavAuthor Commented:
How to customize the distmdl ?
 
0
GKaloskyCommented:
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.
0
migavAuthor Commented:
This database is not connected, how do I change the default settings  for replication ?
0
GKaloskyCommented:
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.
0
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 ?
0
Anthony PerkinsCommented:
Award point to the following comments as they accurately answered the original question:
http:#a31385119
http:#a31389198
http:#a31389592
http:#a31392810
0
Vee_ModCommented:
All,
 
Following an 'Objection' by acperkins (at http://www.experts-exchange.com/Q_26672696.html) 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,
 
Vee_Mod
Community Support Moderator
0
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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.