"Warren Patterson" <des@newsgroups.nospam> wrote in message
news:%23mTTueTNFHA.3356@TK2MSFTNGP12.phx.gbl...
> Hi,
>
> My log file on the publisher for the published database, doesnt seem to
> grow, its always around 1MB, teh log file settings are set to allow the
> file to grow incrementally and everything else seems normal.
>
> After some further investigations I came across an option that should
> apparently be set to false ( Truncate Log on Checkpoint).
>
> SELECT DATABASEPROPERTY ('Northwind', 'IsTruncLog')
>
> after running this, I determined that is was in fact set to TRUE. In
order
> to change it to false, I need to run this procedure
>
> SP_DBOPTION Northwind ,'trunc. log on chkpt.', false
>
> by setting this to false, would this cause any problems with replication
> (Merge Replication, with pull subscribers)?
>
>
> Thanks in advance.
>
> Warren
>
>
>
>
>
>
>

"Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
news:Oqy0c1TNFHA.3156@TK2MSFTNGP15.phx.gbl...
> No, this setting will not affect replication.
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Warren Patterson" <des@newsgroups.nospam> wrote in message
> news:%23mTTueTNFHA.3356@TK2MSFTNGP12.phx.gbl...
> > Hi,
> >
> > My log file on the publisher for the published database, doesnt seem to
> > grow, its always around 1MB, teh log file settings are set to allow the
> > file to grow incrementally and everything else seems normal.
> >
> > After some further investigations I came across an option that should
> > apparently be set to false ( Truncate Log on Checkpoint).
> >
> > SELECT DATABASEPROPERTY ('Northwind', 'IsTruncLog')
> >
> > after running this, I determined that is was in fact set to TRUE. In
> order
> > to change it to false, I need to run this procedure
> >
> > SP_DBOPTION Northwind ,'trunc. log on chkpt.', false
> >
> > by setting this to false, would this cause any problems with replication
> > (Merge Replication, with pull subscribers)?
> >
> >
> > Thanks in advance.
> >
> > Warren
> >
> >
> >
> >
> >
> >
> >
>
>