MS SQL Server - Transaction log ???

Author

Transaction log ???

jorgemiguel.paulino@gmail.com

2005-09-28, 3:23 am

Hi all,

Hi have a database with a huge transaction log file (plus then 13gb)
and I only have 600mb disk space left. I remove the option that allows
increasing log automatically, but there are some things that I don't
know:

1 - If we could not see the transaction log in an easy way, why he
exists?
2 - How can I delete it or how can I erase some information in order
to reduce it?

Can anyone help me?

Tanks in advance
Jorge

Nik Marshall-Blank \(delete fcom for my email addr

2005-09-28, 7:23 am

Please read BOL Shrinking Transaction Logs

--
Nik Marshall-Blank MCSD/MCDBA

<jorgemiguel.paulino@gmail.com> wrote in message
news:1127895012.470667.183410@o13g2000cwo.googlegroups.com...
> Hi all,
>
> Hi have a database with a huge transaction log file (plus then 13gb)
> and I only have 600mb disk space left. I remove the option that allows
> increasing log automatically, but there are some things that I don't
> know:
>
> 1 - If we could not see the transaction log in an easy way, why he
> exists?
> 2 - How can I delete it or how can I erase some information in order
> to reduce it?
>
> Can anyone help me?
>
> Tanks in advance
> Jorge
>

Hari Prasad

2005-09-28, 8:23 pm

Hi,

Use the below URL to shrink the log:-

http://support.microsoft.com/kb/272318/

Thanks
Hari
SQL Server MVP

<jorgemiguel.paulino@gmail.com> wrote in message
news:1127895012.470667.183410@o13g2000cwo.googlegroups.com...
> Hi all,
>
> Hi have a database with a huge transaction log file (plus then 13gb)
> and I only have 600mb disk space left. I remove the option that allows
> increasing log automatically, but there are some things that I don't
> know:
>
> 1 - If we could not see the transaction log in an easy way, why he
> exists?
> 2 - How can I delete it or how can I erase some information in order
> to reduce it?
>
> Can anyone help me?
>
> Tanks in advance
> Jorge
>

JBM

2005-09-30, 3:23 am

I am also in same predicament. Please advice where to run the code that is
mentioned in MS Article from. Is it from DOS Prompt or any other place. I
know it is a very basic question.
Many Thanks
JM
"Hari Prasad" < hari_prasad_k@hotmai
l.com> wrote in message
news:OFHxV1FxFHA.612@TK2MSFTNGP10.phx.gbl...
> Hi,
>
> Use the below URL to shrink the log:-
>
> http://support.microsoft.com/kb/272318/
>
> Thanks
> Hari
> SQL Server MVP
>
> <jorgemiguel.paulino@gmail.com> wrote in message
> news:1127895012.470667.183410@o13g2000cwo.googlegroups.com...
>
>

Sponsored Links