September 7, 2007 at 12:22 am
Hello,
I was browsing through our sql server folder and came across the distmdl.mdf file. There isn't a database connected. I searched around on Internet and this forum but I couldn't really discover what this file exactly is used for.
Could you guys provide me with the following answers:
What is a replication database?
If you haven't got a database attatched, can the file be deleted?
Many thanks,
JR
September 7, 2007 at 12:48 am
Johan,
the file you found is for the distribution database. It's not in use until you configure your server for replication, and even then it might not be used because you can define another server as distributor.
The use of the distribution database in replication depends on the type of replication. In transactional replication it keps track of the teransaction which need to be synchronized at the subscribers. In Snapshot and merge replication the role of the distribution database is a lot more limited. Mainly it just keeps track of which publications have which subscribers.
While you could delete the file if you're not planning to use replication, I wouldn't do so because you never know what requirements come up in the future. So just leave it like it is.
Markus
[font="Verdana"]Markus Bohse[/font]
September 7, 2007 at 3:08 am
Thanks,
I'm still not exactly sure what the distribution dbase doest exactly and what replecation does but I'll leave the files at their location and read my sqlserver for dummies book.
JR
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply