CRM Mobile database log files growth

We have found that the log files from the CRM mobile database can grow to an
enormous size e.g. the log file for one client had grown to 40GB before they
noticed the size. To shrink this log file we had to open the SQL Enterprise
Manager and change the "Properties > Recovery Model" from Full to Simple.

I am hoping someone can tell us why this Recovery Model is set to Full and
not Simple and how this enormous growth occurs in the log files for each CRM
database?

Thanks in advance.

John
Sun Mar 13 23:24:32 CST 2005

you need to backup the database

--
John O'Donnell
Microsoft CRM MVP
http://www.mscrmfaq.us


"brett" <brett@discussions.microsoft.com> wrote in message
news:0EA32B48-D304-49C1-ACC3-FF488639E1C2@microsoft.com...
> We have found that the log files from the CRM mobile database can grow to
an
> enormous size e.g. the log file for one client had grown to 40GB before
they
> noticed the size. To shrink this log file we had to open the SQL
Enterprise
> Manager and change the "Properties > Recovery Model" from Full to Simple.
>
> I am hoping someone can tell us why this Recovery Model is set to Full and
> not Simple and how this enormous growth occurs in the log files for each
CRM
> database?
>
> Thanks in advance.

John
Sun Mar 13 23:27:14 CST 2005

this should help

http://support.microsoft.com/?kbid=873235

--
John O'Donnell
Microsoft CRM MVP
http://www.mscrmfaq.us


"brett" <brett@discussions.microsoft.com> wrote in message
news:0EA32B48-D304-49C1-ACC3-FF488639E1C2@microsoft.com...
> We have found that the log files from the CRM mobile database can grow to
an
> enormous size e.g. the log file for one client had grown to 40GB before
they
> noticed the size. To shrink this log file we had to open the SQL
Enterprise
> Manager and change the "Properties > Recovery Model" from Full to Simple.
>
> I am hoping someone can tell us why this Recovery Model is set to Full and
> not Simple and how this enormous growth occurs in the log files for each
CRM
> database?
>
> Thanks in advance.

brett
Mon Mar 14 02:41:02 CST 2005

Thanks John, we have a number of other SQL databases and we have never seen
growth like this before.

Thanks for this help.

"John O'Donnell" wrote:

> this should help
>
> http://support.microsoft.com/?kbid=873235
>
> --
> John O'Donnell
> Microsoft CRM MVP
> http://www.mscrmfaq.us
>
>
> "brett" <brett@discussions.microsoft.com> wrote in message
> news:0EA32B48-D304-49C1-ACC3-FF488639E1C2@microsoft.com...
> > We have found that the log files from the CRM mobile database can grow to
> an
> > enormous size e.g. the log file for one client had grown to 40GB before
> they
> > noticed the size. To shrink this log file we had to open the SQL
> Enterprise
> > Manager and change the "Properties > Recovery Model" from Full to Simple.
> >
> > I am hoping someone can tell us why this Recovery Model is set to Full and
> > not Simple and how this enormous growth occurs in the log files for each
> CRM
> > database?
> >
> > Thanks in advance.
>
>
>

brett
Mon Mar 14 02:55:02 CST 2005

John, this client has only 1 CRM Mobile user at this stage and yet the
MSCRMMobileSubscription.mdf file is approx. 350MB. This mobile device would
be storing around 1,000 Accounts along with 2,000 contacts, some activities
and notes. This seems to be very large amount of space for these records.
They require 20 mobile users so I am a bit worried about the size of this
database.

"John O'Donnell" wrote:

> this should help
>
> http://support.microsoft.com/?kbid=873235
>
> --
> John O'Donnell
> Microsoft CRM MVP
> http://www.mscrmfaq.us
>
>
> "brett" <brett@discussions.microsoft.com> wrote in message
> news:0EA32B48-D304-49C1-ACC3-FF488639E1C2@microsoft.com...
> > We have found that the log files from the CRM mobile database can grow to
> an
> > enormous size e.g. the log file for one client had grown to 40GB before
> they
> > noticed the size. To shrink this log file we had to open the SQL
> Enterprise
> > Manager and change the "Properties > Recovery Model" from Full to Simple.
> >
> > I am hoping someone can tell us why this Recovery Model is set to Full and
> > not Simple and how this enormous growth occurs in the log files for each
> CRM
> > database?
> >
> > Thanks in advance.
>
>
>

goldenshine
Mon Mar 14 19:51:02 CST 2005

Hi brett,
John is right. you need to backup your database.


"brett" wrote:

> John, this client has only 1 CRM Mobile user at this stage and yet the
> MSCRMMobileSubscription.mdf file is approx. 350MB. This mobile device would
> be storing around 1,000 Accounts along with 2,000 contacts, some activities
> and notes. This seems to be very large amount of space for these records.
> They require 20 mobile users so I am a bit worried about the size of this
> database.
>
> "John O'Donnell" wrote:
>
> > this should help
> >
> > http://support.microsoft.com/?kbid=873235
> >
> > --
> > John O'Donnell
> > Microsoft CRM MVP
> > http://www.mscrmfaq.us
> >
> >
> > "brett" <brett@discussions.microsoft.com> wrote in message
> > news:0EA32B48-D304-49C1-ACC3-FF488639E1C2@microsoft.com...
> > > We have found that the log files from the CRM mobile database can grow to
> > an
> > > enormous size e.g. the log file for one client had grown to 40GB before
> > they
> > > noticed the size. To shrink this log file we had to open the SQL
> > Enterprise
> > > Manager and change the "Properties > Recovery Model" from Full to Simple.
> > >
> > > I am hoping someone can tell us why this Recovery Model is set to Full and
> > > not Simple and how this enormous growth occurs in the log files for each
> > CRM
> > > database?
> > >
> > > Thanks in advance.
> >
> >
> >

John
Mon Mar 14 22:55:16 CST 2005

thanks for the followup - i'd be interested (as would others) to here your
experience with the mobile client on this group

--
John O'Donnell
Microsoft CRM MVP
http://www.mscrmfaq.us


"goldenshine" <goldenshine@discussions.microsoft.com> wrote in message
news:C83843F9-B8D7-4D29-A9B9-86B9C6623938@microsoft.com...
> Hi brett,
> John is right. you need to backup your database.
>
>
> "brett" wrote:
>
> > John, this client has only 1 CRM Mobile user at this stage and yet the
> > MSCRMMobileSubscription.mdf file is approx. 350MB. This mobile device
would
> > be storing around 1,000 Accounts along with 2,000 contacts, some
activities
> > and notes. This seems to be very large amount of space for these
records.
> > They require 20 mobile users so I am a bit worried about the size of
this
> > database.
> >
> > "John O'Donnell" wrote:
> >
> > > this should help
> > >
> > > http://support.microsoft.com/?kbid=873235
> > >
> > > --
> > > John O'Donnell
> > > Microsoft CRM MVP
> > > http://www.mscrmfaq.us
> > >
> > >
> > > "brett" <brett@discussions.microsoft.com> wrote in message
> > > news:0EA32B48-D304-49C1-ACC3-FF488639E1C2@microsoft.com...
> > > > We have found that the log files from the CRM mobile database can
grow to
> > > an
> > > > enormous size e.g. the log file for one client had grown to 40GB
before
> > > they
> > > > noticed the size. To shrink this log file we had to open the SQL
> > > Enterprise
> > > > Manager and change the "Properties > Recovery Model" from Full to
Simple.
> > > >
> > > > I am hoping someone can tell us why this Recovery Model is set to
Full and
> > > > not Simple and how this enormous growth occurs in the log files for
each
> > > CRM
> > > > database?
> > > >
> > > > Thanks in advance.
> > >
> > >
> > >