|
Home > Archive > microsoft.public.sqlserver.server > October 2002 > closing an open transaction in log file
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
closing an open transaction in log file
|
|
| AKIN HOCA 2002-10-30, 5:23 pm |
| Hi,
my database is not truncating log. I found that there is
an open transaction, I have some LSN numbers. How can I
close those open transactions? I have re-started server,
still same.
Thanks,
| |
| Uri Dimant 2002-10-31, 12:23 am |
| Akin
Look at dbcc loginfo
If you have activate transaction then in a test table perfom some insert to
move activate transaction to the end of the file
AKIN HOCA <akinh@yahoo.com> wrote in message
news:196601c28069$1105a820$36e
f2ecf@tkmsftngxa12...
> Hi,
> my database is not truncating log. I found that there is
> an open transaction, I have some LSN numbers. How can I
> close those open transactions? I have re-started server,
> still same.
> Thanks,
| |
| Tibor Karaszi 2002-10-31, 1:23 am |
| You mean you restarted the server and you still have open transactions?
This shouldn't be possible unless there's replication involved.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver
"AKIN HOCA" <akinh@yahoo.com> wrote in message
news:196601c28069$1105a820$36e
f2ecf@tkmsftngxa12...
> Hi,
> my database is not truncating log. I found that there is
> an open transaction, I have some LSN numbers. How can I
> close those open transactions? I have re-started server,
> still same.
> Thanks,
|
|
|
|
|