I'm trying to shrink and oversized Log file. I've done a complete backup but
when issuing the shrinkfile command I get this:

Cannot shrink log file 2 (xxx_web_Log) because all logical log files are in
use.

The OpenTran command gives me this:
Transaction information for database 'XXX_web'.

Replicated Transaction Information:
Oldest distributed LSN : (259728:69:12)
Oldest non-distributed LSN : (259737:153:1)

What is it and how do I kill it so I can shrink the file?

You either have or have had transactional replication configured for this database. If you have it,
you need to troubleshoot if the log reader has stopped. If you no longer have it, Google for how to
remove replication config (sp_repldone, perhaps, but I'm not sure).

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"TLuebke" <TLuebke@discussions.microsoft.com> wrote in message
news:7554752E-6A53-4764-A67A-CFC7E7115603@microsoft.com...
> I'm trying to shrink and oversized Log file. I've done a complete backup but
> when issuing the shrinkfile command I get this:
>
> Cannot shrink log file 2 (xxx_web_Log) because all logical log files are in
> use.
>
> The OpenTran command gives me this:
> Transaction information for database 'XXX_web'.
>
> Replicated Transaction Information:
> Oldest distributed LSN : (259728:69:12)
> Oldest non-distributed LSN : (259737:153:1)
>
> What is it and how do I kill it so I can shrink the file?
>
>

When I check the log reader properties the stop button is greyed out and the
start button has focus. If I try to start it throws an error that it can't
retrieve agent status.

Is there another way to verify and stop this agent?

"Tibor Karaszi" wrote:

> You either have or have had transactional replication configured for this database. If you have it,
> you need to troubleshoot if the log reader has stopped. If you no longer have it, Google for how to
> remove replication config (sp_repldone, perhaps, but I'm not sure).
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
>
> "TLuebke" <TLuebke@discussions.microsoft.com> wrote in message
> news:7554752E-6A53-4764-A67A-CFC7E7115603@microsoft.com...
> > I'm trying to shrink and oversized Log file. I've done a complete backup but
> > when issuing the shrinkfile command I get this:
> >
> > Cannot shrink log file 2 (xxx_web_Log) because all logical log files are in
> > use.
> >
> > The OpenTran command gives me this:
> > Transaction information for database 'XXX_web'.
> >
> > Replicated Transaction Information:
> > Oldest distributed LSN : (259728:69:12)
> > Oldest non-distributed LSN : (259737:153:1)
> >
> > What is it and how do I kill it so I can shrink the file?
> >
> >
>
>

Consider posting to a replication group, or perhaps start a new thread with an appropriate Subject.
I'm no replication expert, so I would be in for BOL reading and Google, which I guess you are as
good at as I am...

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"TLuebke" <TLuebke@discussions.microsoft.com> wrote in message
news:BE2EBF2F-ECA6-4F94-B832-922330C258F5@microsoft.com...
> When I check the log reader properties the stop button is greyed out and the
> start button has focus. If I try to start it throws an error that it can't
> retrieve agent status.
>
> Is there another way to verify and stop this agent?
>
> "Tibor Karaszi" wrote:
>
>> You either have or have had transactional replication configured for this database. If you have
>> it,
>> you need to troubleshoot if the log reader has stopped. If you no longer have it, Google for how
>> to
>> remove replication config (sp_repldone, perhaps, but I'm not sure).
>>
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>>
>> "TLuebke" <TLuebke@discussions.microsoft.com> wrote in message
>> news:7554752E-6A53-4764-A67A-CFC7E7115603@microsoft.com...
>> > I'm trying to shrink and oversized Log file. I've done a complete backup but
>> > when issuing the shrinkfile command I get this:
>> >
>> > Cannot shrink log file 2 (xxx_web_Log) because all logical log files are in
>> > use.
>> >
>> > The OpenTran command gives me this:
>> > Transaction information for database 'XXX_web'.
>> >
>> > Replicated Transaction Information:
>> > Oldest distributed LSN : (259728:69:12)
>> > Oldest non-distributed LSN : (259737:153:1)
>> >
>> > What is it and how do I kill it so I can shrink the file?
>> >
>> >
>>
>>