Cannot truncate logfile in SQL server 2000

Nilkanth Desai
nsdesai@.tis-world.com
I am using SQL Server 2000. In this case database size is 750 MB and since
last 10 days its logfile is constantly increasing its size. Since last 2 day
s
it has crossed 14GB. Thses logfiles are having extension of .ldf. I have
tried shrink database option from Enterprise manager and used DBCC from quer
y
analyser. But this logfile did not truncated.
Can anyone tell me solution for this problem.8f84bacebad4b881" target="_blank">http://groups.google.com.au/group/m...f84bacebad4b881
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Nilkanth Desai" <Nilkanth Desai@.discussions.microsoft.com> wrote in message
news:D70F6F79-84F6-4F9F-B514-885FB86D8B18@.microsoft.com...
> Nilkanth Desai
> nsdesai@.tis-world.com
> I am using SQL Server 2000. In this case database size is 750 MB and since
> last 10 days its logfile is constantly increasing its size. Since last 2
> days
> it has crossed 14GB. Thses logfiles are having extension of .ldf. I have
> tried shrink database option from Enterprise manager and used DBCC from
> query
> analyser. But this logfile did not truncated.
> Can anyone tell me solution for this problem.