sql2k sp3
Im trying to truncate a tlog on a replicated db. It wont
let me untill the results of dbcc opentran are empty. Im
the only one on this test box and can verify that all data
has made it to the subscriber. But still, even after 20
minutes of waiting, I run dbcc opentran and its not empty.
So my question is, how long after my last transaction is
committed will dbcc opentran be empty? Is there a way to
speed this up?
TIA, ChrisThis is a multi-part message in MIME format.
--=_NextPart_000_0322_01C3CE0C.82054A20
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
How about finding out why there is an open transaction? Run DBCC
INPUTBUFFER on the SPID identified by DBCC OPENTRAN.
--
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"chris" <anonymous@.discussions.microsoft.com> wrote in message
news:018601c3ce35$3497d4a0$a101280a@.phx.gbl...
sql2k sp3
Im trying to truncate a tlog on a replicated db. It wont
let me untill the results of dbcc opentran are empty. Im
the only one on this test box and can verify that all data
has made it to the subscriber. But still, even after 20
minutes of waiting, I run dbcc opentran and its not empty.
So my question is, how long after my last transaction is
committed will dbcc opentran be empty? Is there a way to
speed this up?
TIA, Chris
--=_NextPart_000_0322_01C3CE0C.82054A20
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
How about finding out why there is an =open transaction? Run DBCC INPUTBUFFER on the SPID identified by DBCC OPENTRAN.
-- Tom
---T=homas A. Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL =Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql
"chris" wrote in message news:018601c3ce35$34=97d4a0$a101280a@.phx.gbl...sql2k sp3 Im trying to truncate a tlog on a replicated db. It wont =let me untill the results of dbcc opentran are empty. Im the only one on =this test box and can verify that all data has made it to the subscriber. But =still, even after 20 minutes of waiting, I run dbcc opentran and its not =empty. So my question is, how long after my last transaction is =committed will dbcc opentran be empty? Is there a way to speed this up?TIA, =Chris
--=_NextPart_000_0322_01C3CE0C.82054A20--|||DBCC Opentran doesnt return a spid. I run select * from
master..sysprocesses where open_tran > 0 and get
EventType Parameters
EventInfo
-- -- --
----
Language Event 0 sp_MSget_last_transaction
@.publisher_id = 0, @.publisher_db = N'adv084',
@.for_truncate = 0x1
In addition to this, I forgot to mention that I can clear
this up by running sp_repldone as describer in BOL but it
causes its own set of problems.
>--Original Message--
>How about finding out why there is an open transaction?
Run DBCC
>INPUTBUFFER on the SPID identified by DBCC OPENTRAN.
>--
>Tom
>----
--
>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>SQL Server MVP
>Columnist, SQL Server Professional
>Toronto, ON Canada
>www.pinnaclepublishing.com/sql
>
>"chris" <anonymous@.discussions.microsoft.com> wrote in
message
>news:018601c3ce35$3497d4a0$a101280a@.phx.gbl...
>sql2k sp3
>Im trying to truncate a tlog on a replicated db. It wont
>let me untill the results of dbcc opentran are empty. Im
>the only one on this test box and can verify that all data
>has made it to the subscriber. But still, even after 20
>minutes of waiting, I run dbcc opentran and its not empty.
>So my question is, how long after my last transaction is
>committed will dbcc opentran be empty? Is there a way to
>speed this up?
>TIA, Chris
>|||This is a multi-part message in MIME format.
--=_NextPart_000_0367_01C3CE11.6946A830
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Replication uses transaction log entries. Likely, it is waiting to take the
last transaction from the transaction log to the distribution database.
--
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"chris" <anonymous@.discussions.microsoft.com> wrote in message
news:01e701c3ce3a$5f3304f0$a101280a@.phx.gbl...
DBCC Opentran doesnt return a spid. I run select * from
master..sysprocesses where open_tran > 0 and get
EventType Parameters
EventInfo
-- -- --
----
Language Event 0 sp_MSget_last_transaction
@.publisher_id = 0, @.publisher_db = N'adv084',
@.for_truncate = 0x1
In addition to this, I forgot to mention that I can clear
this up by running sp_repldone as describer in BOL but it
causes its own set of problems.
>--Original Message--
>How about finding out why there is an open transaction?
Run DBCC
>INPUTBUFFER on the SPID identified by DBCC OPENTRAN.
>--
>Tom
>----
--
>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>SQL Server MVP
>Columnist, SQL Server Professional
>Toronto, ON Canada
>www.pinnaclepublishing.com/sql
>
>"chris" <anonymous@.discussions.microsoft.com> wrote in
message
>news:018601c3ce35$3497d4a0$a101280a@.phx.gbl...
>sql2k sp3
>Im trying to truncate a tlog on a replicated db. It wont
>let me untill the results of dbcc opentran are empty. Im
>the only one on this test box and can verify that all data
>has made it to the subscriber. But still, even after 20
>minutes of waiting, I run dbcc opentran and its not empty.
>So my question is, how long after my last transaction is
>committed will dbcc opentran be empty? Is there a way to
>speed this up?
>TIA, Chris
>
--=_NextPart_000_0367_01C3CE11.6946A830
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Replication uses transaction log =entries. Likely, it is waiting to take the last transaction from the =transaction log to the distribution database.
-- Tom
---T=homas A. Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL =Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql
"chris" wrote in message news:01e701c3ce3a$5f=3304f0$a101280a@.phx.gbl...DBCC Opentran doesnt return a spid. I run select * from =master..sysprocesses where open_tran > 0 and =getEventType Parameters EventInfo = &=nbsp; &n=bsp; &nb=sp; &nb=sp; &nbs=p; -- -- ----=-- Language Event =0 sp_MSget_last_transaction @.publisher_id =3D 0, @.publisher_db =3D =N'adv084', @.for_truncate =3D 0x1In addition to this, I forgot to =mention that I can clear this up by running sp_repldone as describer in BOL but it causes its own set of problems.>--Original Message-->How about finding out why there is an open transaction? Run DBCC>INPUTBUFFER on the SPID =identified by DBCC OPENTRAN.>>-->Tom>>--=----->Thomas A. Moreau, BSc, PhD, MCSE, MCDBA>SQL Server MVP>Columnist, =SQL Server Professional>Toronto, ON Canada>www.pinnaclepublishing.com/sql>>>"chri=s" wrote in message>news:018601c3ce35$3497d4a0$a101280a@.phx.gbl...>=sql2k sp3>>Im trying to truncate a tlog on a replicated db. It wont>let me untill the results of dbcc opentran are empty. =Im>the only one on this test box and can verify that all data>has made =it to the subscriber. But still, even after 20>minutes of waiting, I run =dbcc opentran and its not empty.>So my question is, how long after my =last transaction is>committed will dbcc opentran be empty? Is there a =way to>speed this up?>>TIA, Chris>
--=_NextPart_000_0367_01C3CE11.6946A830--|||But its already been distributed. I have verified this by
rowcounts.
>--Original Message--
>Replication uses transaction log entries. Likely, it is
waiting to take the
>last transaction from the transaction log to the
distribution database.
>--
>Tom
>----
--
>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>SQL Server MVP
>Columnist, SQL Server Professional
>Toronto, ON Canada
>www.pinnaclepublishing.com/sql
>
>"chris" <anonymous@.discussions.microsoft.com> wrote in
message
>news:01e701c3ce3a$5f3304f0$a101280a@.phx.gbl...
>DBCC Opentran doesnt return a spid. I run select * from
>master..sysprocesses where open_tran > 0 and get
>EventType Parameters
>EventInfo
>-- -- --
-
>----
>Language Event 0 sp_MSget_last_transaction
>@.publisher_id = 0, @.publisher_db = N'adv084',
>@.for_truncate = 0x1
>In addition to this, I forgot to mention that I can clear
>this up by running sp_repldone as describer in BOL but it
>causes its own set of problems.
>
>>--Original Message--
>>How about finding out why there is an open transaction?
>Run DBCC
>>INPUTBUFFER on the SPID identified by DBCC OPENTRAN.
>>--
>>Tom
>>----
-
>--
>>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>>SQL Server MVP
>>Columnist, SQL Server Professional
>>Toronto, ON Canada
>>www.pinnaclepublishing.com/sql
>>
>>"chris" <anonymous@.discussions.microsoft.com> wrote in
>message
>>news:018601c3ce35$3497d4a0$a101280a@.phx.gbl...
>>sql2k sp3
>>Im trying to truncate a tlog on a replicated db. It wont
>>let me untill the results of dbcc opentran are empty. Im
>>the only one on this test box and can verify that all
data
>>has made it to the subscriber. But still, even after 20
>>minutes of waiting, I run dbcc opentran and its not
empty.
>>So my question is, how long after my last transaction is
>>committed will dbcc opentran be empty? Is there a way to
>>speed this up?
>>TIA, Chris
>|||This is a multi-part message in MIME format.
--=_NextPart_000_03C8_01C3CE15.765C2050
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
I'm surprised that DBCC OPENTRAN doesn't give you a SPID - unless the open
tran is started from another database. When you run:
select * from
master..sysprocesses where open_tran > 0
what database does it tell you?
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"chris" <anonymous@.discussions.microsoft.com> wrote in message
news:007f01c3ce3d$14e64cb0$a501280a@.phx.gbl...
But its already been distributed. I have verified this by
rowcounts.
>--Original Message--
>Replication uses transaction log entries. Likely, it is
waiting to take the
>last transaction from the transaction log to the
distribution database.
>--
>Tom
>----
--
>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>SQL Server MVP
>Columnist, SQL Server Professional
>Toronto, ON Canada
>www.pinnaclepublishing.com/sql
>
>"chris" <anonymous@.discussions.microsoft.com> wrote in
message
>news:01e701c3ce3a$5f3304f0$a101280a@.phx.gbl...
>DBCC Opentran doesnt return a spid. I run select * from
>master..sysprocesses where open_tran > 0 and get
>EventType Parameters
>EventInfo
>-- -- --
-
>----
>Language Event 0 sp_MSget_last_transaction
>@.publisher_id = 0, @.publisher_db = N'adv084',
>@.for_truncate = 0x1
>In addition to this, I forgot to mention that I can clear
>this up by running sp_repldone as describer in BOL but it
>causes its own set of problems.
>
>>--Original Message--
>>How about finding out why there is an open transaction?
>Run DBCC
>>INPUTBUFFER on the SPID identified by DBCC OPENTRAN.
>>--
>>Tom
>>----
-
>--
>>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>>SQL Server MVP
>>Columnist, SQL Server Professional
>>Toronto, ON Canada
>>www.pinnaclepublishing.com/sql
>>
>>"chris" <anonymous@.discussions.microsoft.com> wrote in
>message
>>news:018601c3ce35$3497d4a0$a101280a@.phx.gbl...
>>sql2k sp3
>>Im trying to truncate a tlog on a replicated db. It wont
>>let me untill the results of dbcc opentran are empty. Im
>>the only one on this test box and can verify that all
data
>>has made it to the subscriber. But still, even after 20
>>minutes of waiting, I run dbcc opentran and its not
empty.
>>So my question is, how long after my last transaction is
>>committed will dbcc opentran be empty? Is there a way to
>>speed this up?
>>TIA, Chris
>
--=_NextPart_000_03C8_01C3CE15.765C2050
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
I'm surprised that DBCC OPENTRAN =doesn't give you a SPID - unless the open tran is started from another database. =When you run:
select * =frommaster..sysprocesses where open_tran > 0
what database does it tell =you?
-- Tom
---T=homas A. Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL =Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql
"chris" wrote in message news:007f01c3ce3d$14=e64cb0$a501280a@.phx.gbl...But its already been distributed. I have verified this by rowcounts.>--Original =Message-->Replication uses transaction log entries. Likely, it is waiting to take =the>last transaction from the transaction log to the distribution database.>>-->Tom>>--=----->Thomas A. Moreau, BSc, PhD, MCSE, MCDBA>SQL Server MVP>Columnist, =SQL Server Professional>Toronto, ON Canada>www.pinnaclepublishing.com/sql>>>"chri=s" wrote in message>news:01e701c3ce3a$5f3304f0$a101280a@.phx.gbl...>=DBCC Opentran doesnt return a spid. I run select * =from>master..sysprocesses where open_tran > 0 and get>>EventType Parameters>EventInfo>>-- -- --->--=-->Language Event 0 sp_MSget_last_transaction>@.publisher_id =3D 0, @.publisher_db =3D N'adv084',>@.for_truncate =3D 0x1>>In addition to =this, I forgot to mention that I can clear>this up by running sp_repldone =as describer in BOL but it>causes its own set of problems.>>>>--Original Message-->How about finding out why there is an open transaction?>Run DBCC>INPUTBUFFER on the SPID =identified by DBCC OPENTRAN.>>-->Tom>>>=;----->--=-->Thomas A. Moreau, BSc, PhD, MCSE, MCDBA>SQL Server =MVP>Columnist, SQL Server Professional>Toronto, ON Canada>www.pinnaclepublishing.com/sql>>>"chris" wrote in>message>news:018601c3ce35$3497d4a0$a101280a@.phx.gbl.=..>sql2k sp3>>Im trying to truncate a tlog on a replicated =db. It wont>let me untill the results of dbcc opentran are empty. Im>the only one on this test box and can verify that all data>has made it to the subscriber. But still, even after =20>minutes of waiting, I run dbcc opentran and its not empty.>So my question is, how long after my last =transaction is>committed will dbcc opentran be empty? Is there a way to>speed this up?>>TIA, Chris>>
--=_NextPart_000_03C8_01C3CE15.765C2050--|||It tells me the Distribution DB. But FYI, I already tried
stopping the distribution and log reader agents to see if
that made a difference but it didnt help.
>--Original Message--
>I'm surprised that DBCC OPENTRAN doesn't give you a SPID -
unless the open
>tran is started from another database. When you run:
>select * from
>master..sysprocesses where open_tran > 0
>what database does it tell you?
>
>--
>Tom
>----
--
>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>SQL Server MVP
>Columnist, SQL Server Professional
>Toronto, ON Canada
>www.pinnaclepublishing.com/sql
>
>"chris" <anonymous@.discussions.microsoft.com> wrote in
message
>news:007f01c3ce3d$14e64cb0$a501280a@.phx.gbl...
>But its already been distributed. I have verified this by
>rowcounts.
>
>>--Original Message--
>>Replication uses transaction log entries. Likely, it is
>waiting to take the
>>last transaction from the transaction log to the
>distribution database.
>>--
>>Tom
>>----
-
>--
>>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>>SQL Server MVP
>>Columnist, SQL Server Professional
>>Toronto, ON Canada
>>www.pinnaclepublishing.com/sql
>>
>>"chris" <anonymous@.discussions.microsoft.com> wrote in
>message
>>news:01e701c3ce3a$5f3304f0$a101280a@.phx.gbl...
>>DBCC Opentran doesnt return a spid. I run select * from
>>master..sysprocesses where open_tran > 0 and get
>>EventType Parameters
>>EventInfo
>>-- -- --
-
>-
>>----
-
>>Language Event 0 sp_MSget_last_transaction
>>@.publisher_id = 0, @.publisher_db = N'adv084',
>>@.for_truncate = 0x1
>>In addition to this, I forgot to mention that I can clear
>>this up by running sp_repldone as describer in BOL but it
>>causes its own set of problems.
>>
>>--Original Message--
>>How about finding out why there is an open transaction?
>>Run DBCC
>>INPUTBUFFER on the SPID identified by DBCC OPENTRAN.
>>--
>>Tom
>>---
-
>-
>>--
>>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>>SQL Server MVP
>>Columnist, SQL Server Professional
>>Toronto, ON Canada
>>www.pinnaclepublishing.com/sql
>>
>>"chris" <anonymous@.discussions.microsoft.com> wrote in
>>message
>>news:018601c3ce35$3497d4a0$a101280a@.phx.gbl...
>>sql2k sp3
>>Im trying to truncate a tlog on a replicated db. It wont
>>let me untill the results of dbcc opentran are empty. Im
>>the only one on this test box and can verify that all
>data
>>has made it to the subscriber. But still, even after 20
>>minutes of waiting, I run dbcc opentran and its not
>empty.
>>So my question is, how long after my last transaction is
>>committed will dbcc opentran be empty? Is there a way to
>>speed this up?
>>TIA, Chris
>>
>|||This is a multi-part message in MIME format.
--=_NextPart_000_0407_01C3CE18.8CC84D20
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
You may want to open a ticket with MS Product Support Services (PSS). This
may be a bug. :-(
--
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"chris" <anonymous@.discussions.microsoft.com> wrote in message
news:073201c3ce41$bf465700$a001280a@.phx.gbl...
It tells me the Distribution DB. But FYI, I already tried
stopping the distribution and log reader agents to see if
that made a difference but it didnt help.
>--Original Message--
>I'm surprised that DBCC OPENTRAN doesn't give you a SPID -
unless the open
>tran is started from another database. When you run:
>select * from
>master..sysprocesses where open_tran > 0
>what database does it tell you?
>
>--
>Tom
>----
--
>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>SQL Server MVP
>Columnist, SQL Server Professional
>Toronto, ON Canada
>www.pinnaclepublishing.com/sql
>
>"chris" <anonymous@.discussions.microsoft.com> wrote in
message
>news:007f01c3ce3d$14e64cb0$a501280a@.phx.gbl...
>But its already been distributed. I have verified this by
>rowcounts.
>
>>--Original Message--
>>Replication uses transaction log entries. Likely, it is
>waiting to take the
>>last transaction from the transaction log to the
>distribution database.
>>--
>>Tom
>>----
-
>--
>>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>>SQL Server MVP
>>Columnist, SQL Server Professional
>>Toronto, ON Canada
>>www.pinnaclepublishing.com/sql
>>
>>"chris" <anonymous@.discussions.microsoft.com> wrote in
>message
>>news:01e701c3ce3a$5f3304f0$a101280a@.phx.gbl...
>>DBCC Opentran doesnt return a spid. I run select * from
>>master..sysprocesses where open_tran > 0 and get
>>EventType Parameters
>>EventInfo
>>-- -- --
-
>-
>>----
-
>>Language Event 0 sp_MSget_last_transaction
>>@.publisher_id = 0, @.publisher_db = N'adv084',
>>@.for_truncate = 0x1
>>In addition to this, I forgot to mention that I can clear
>>this up by running sp_repldone as describer in BOL but it
>>causes its own set of problems.
>>
>>--Original Message--
>>How about finding out why there is an open transaction?
>>Run DBCC
>>INPUTBUFFER on the SPID identified by DBCC OPENTRAN.
>>--
>>Tom
>>---
-
>-
>>--
>>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>>SQL Server MVP
>>Columnist, SQL Server Professional
>>Toronto, ON Canada
>>www.pinnaclepublishing.com/sql
>>
>>"chris" <anonymous@.discussions.microsoft.com> wrote in
>>message
>>news:018601c3ce35$3497d4a0$a101280a@.phx.gbl...
>>sql2k sp3
>>Im trying to truncate a tlog on a replicated db. It wont
>>let me untill the results of dbcc opentran are empty. Im
>>the only one on this test box and can verify that all
>data
>>has made it to the subscriber. But still, even after 20
>>minutes of waiting, I run dbcc opentran and its not
>empty.
>>So my question is, how long after my last transaction is
>>committed will dbcc opentran be empty? Is there a way to
>>speed this up?
>>TIA, Chris
>>
>
--=_NextPart_000_0407_01C3CE18.8CC84D20
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
You may want to open a ticket with MS =Product Support Services (PSS). This may be a bug. :-(
-- Tom
---T=homas A. Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL =Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql
"chris" wrote in message news:073201c3ce41$bf=465700$a001280a@.phx.gbl...It tells me the Distribution DB. But FYI, I already tried stopping the distribution and log reader agents to see if that made a difference =but it didnt help.>--Original Message-->I'm =surprised that DBCC OPENTRAN doesn't give you a SPID - unless the =open>tran is started from another database. When you run:>>select =* from>master..sysprocesses where open_tran > =0>>what database does it tell you?>>>-->Tom>>--=----->Thomas A. Moreau, BSc, PhD, MCSE, MCDBA>SQL Server MVP>Columnist, =SQL Server Professional>Toronto, ON Canada>www.pinnaclepublishing.com/sql>>>"chri=s" wrote in message>news:007f01c3ce3d$14e64cb0$a501280a@.phx.gbl...>=But its already been distributed. I have verified this by>rowcounts.>>>--Original Message-->Replication uses transaction log entries. =Likely, it is>waiting to take the>last transaction from the transaction log to the>distribution database.>>-->Tom>>>=;----->--=-->Thomas A. Moreau, BSc, PhD, MCSE, MCDBA>SQL Server =MVP>Columnist, SQL Server Professional>Toronto, ON Canada>www.pinnaclepublishing.com/sql>>>"chris" wrote in>message>news:01e701c3ce3a$5f3304f0$a101280a@.phx.gbl.=..>DBCC Opentran doesnt return a spid. I run select * from>master..sysprocesses where open_tran > 0 and get>>EventType Parameters>EventInfo>>-- =-- --->->--=---->Language Event 0 sp_MSget_last_transaction>@.publisher_id =3D 0, @.publisher_db ==3D N'adv084',>@.for_truncate =3D 0x1>>In =addition to this, I forgot to mention that I can clear>this up by running =sp_repldone as describer in BOL but it>causes its own set of problems.>>>>--Origina=l Message-->How about finding out why there is an open transaction?>Run DBCC>INPUTBUFFER on the SPID identified by DBCC OPENTRAN.>>-->Tom>>=;>>----=--->->-->Thomas A. Moreau, BSc, PhD, MCSE, MCDBA>SQL Server MVP>Columnist, SQL Server =Professional>Toronto, ON Canada>www.pinnaclepublishing.com/sql>&=gt;>>>"chris" wrote in>message>news:018601c3ce35$3497d4a0$a101280a@.=phx.gbl...>sql2k sp3>>Im trying to truncate a tlog on a =replicated db. It wont>let me untill the results of dbcc opentran =are empty. Im>the only one on this test box and can verify that all>data>has made it to the subscriber. But still, =even after 20>minutes of waiting, I run dbcc opentran and its not>empty.>So my question is, how long after my =last transaction is>committed will dbcc opentran be empty? Is =there a way to>speed this up?>>TIA, =Chris>>>
--=_NextPart_000_0407_01C3CE18.8CC84D20--|||:-(
Thanks for all the help.
>--Original Message--
>You may want to open a ticket with MS Product Support
Services (PSS). This
>may be a bug. :-(
>--
>Tom
>----
--
>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>SQL Server MVP
>Columnist, SQL Server Professional
>Toronto, ON Canada
>www.pinnaclepublishing.com/sql
>
>"chris" <anonymous@.discussions.microsoft.com> wrote in
message
>news:073201c3ce41$bf465700$a001280a@.phx.gbl...
>It tells me the Distribution DB. But FYI, I already tried
>stopping the distribution and log reader agents to see if
>that made a difference but it didnt help.
>
>>--Original Message--
>>I'm surprised that DBCC OPENTRAN doesn't give you a
SPID -
> unless the open
>>tran is started from another database. When you run:
>>select * from
>>master..sysprocesses where open_tran > 0
>>what database does it tell you?
>>
>>--
>>Tom
>>----
-
>--
>>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>>SQL Server MVP
>>Columnist, SQL Server Professional
>>Toronto, ON Canada
>>www.pinnaclepublishing.com/sql
>>
>>"chris" <anonymous@.discussions.microsoft.com> wrote in
>message
>>news:007f01c3ce3d$14e64cb0$a501280a@.phx.gbl...
>>But its already been distributed. I have verified this by
>>rowcounts.
>>
>>--Original Message--
>>Replication uses transaction log entries. Likely, it is
>>waiting to take the
>>last transaction from the transaction log to the
>>distribution database.
>>--
>>Tom
>>---
-
>-
>>--
>>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>>SQL Server MVP
>>Columnist, SQL Server Professional
>>Toronto, ON Canada
>>www.pinnaclepublishing.com/sql
>>
>>"chris" <anonymous@.discussions.microsoft.com> wrote in
>>message
>>news:01e701c3ce3a$5f3304f0$a101280a@.phx.gbl...
>>DBCC Opentran doesnt return a spid. I run select * from
>>master..sysprocesses where open_tran > 0 and get
>>EventType Parameters
>>EventInfo
>>-- -- --
-
>-
>>-
>>---
-
>-
>>Language Event 0 sp_MSget_last_transaction
>>@.publisher_id = 0, @.publisher_db = N'adv084',
>>@.for_truncate = 0x1
>>In addition to this, I forgot to mention that I can
clear
>>this up by running sp_repldone as describer in BOL but
it
>>causes its own set of problems.
>>
>>--Original Message--
>>How about finding out why there is an open transaction?
>>Run DBCC
>>INPUTBUFFER on the SPID identified by DBCC OPENTRAN.
>>--
>>Tom
>>----
-
>-
>>-
>>--
>>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>>SQL Server MVP
>>Columnist, SQL Server Professional
>>Toronto, ON Canada
>>www.pinnaclepublishing.com/sql
>>
>>"chris" <anonymous@.discussions.microsoft.com> wrote in
>>message
>>news:018601c3ce35$3497d4a0$a101280a@.phx.gbl...
>>sql2k sp3
>>Im trying to truncate a tlog on a replicated db. It
wont
>>let me untill the results of dbcc opentran are empty.
Im
>>the only one on this test box and can verify that all
>>data
>>has made it to the subscriber. But still, even after 20
>>minutes of waiting, I run dbcc opentran and its not
>>empty.
>>So my question is, how long after my last transaction
is
>>committed will dbcc opentran be empty? Is there a way
to
>>speed this up?
>>TIA, Chris
>>
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment