Just wondering if anyone can tell me what the purpose of this particular
database is?

The reason I ask is that it is huge on my system, over a gig in size (and
growing about 10MB per day), but the MSCRM database is only about 350MB in
size. Does it have anything to do with the replication publications (it
looks like it does)?

Assuming it is, are the replication publications something I really need,
only having a single SQL server? I'm not real familiar with this aspect of
MSSQL, it's just that I'm really shaking my head at this Distribution
database size. I've truncated the logs and shrunk the database, but it's
still huge. There's no way for the amount of data we have that the total
size of the CRM data should be about 1.5GB. It just seems excessive.

Glen Cook

This database is used for the replication with the Outlook client. So,
unless you don't have any Sales users that use the Outlook client, you need
this database. I'm not sure what you can do to shrink this.

"Glen Cook" <gcook@iname.com> wrote in message
news:eKGP4TtUDHA.2328@TK2MSFTNGP12.phx.gbl...
Just wondering if anyone can tell me what the purpose of this particular
database is?

The reason I ask is that it is huge on my system, over a gig in size (and
growing about 10MB per day), but the MSCRM database is only about 350MB in
size. Does it have anything to do with the replication publications (it
looks like it does)?

Assuming it is, are the replication publications something I really need,
only having a single SQL server? I'm not real familiar with this aspect of
MSSQL, it's just that I'm really shaking my head at this Distribution
database size. I've truncated the logs and shrunk the database, but it's
still huge. There's no way for the amount of data we have that the total
size of the CRM data should be about 1.5GB. It just seems excessive.

Glen Cook

Maybe check which security roles you are assigning to you users. If they too
much data, the sync wll take too long.
"Matt Parks" <Matt.Parks@removetoX_XRevereGroup.Com> wrote in message
news:Oypq3NsVDHA.1072@TK2MSFTNGP12.phx.gbl...

Thanks for the responses. I'm going to try and change some of the settings
for the replication publictions and see what that does. Taking a snapshot
every five minutes seems a bit excessive for my particular situation, and I
see the setting is to keep replication metadata indefinitely, so I'll play
with these a bit and see what happens. I only have one client using the
Outlook client, and it's on a desktop, so it never syncs to go offline.

As an aside, I'm not a real big fan of the Outlook client. For the overhead
it incurs, I don't see that much benefit, in our particular situation. Our
people do just fine with the browser-based app.

Glen

<mark.milligan@palominohill.com> wrote in message
news:eagjG8%23VDHA.1680@tk2msftngp13.phx.gbl...