Transaction log ???

[jorgemiguel.paulino]

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

[Simon Hayes]

I don't really understand your first question, but the log is there to
ensure that all changes to the database can be rolled back/forward if
necessary, such as when the server crashes. See "Transaction Logs" in
Books Online. As for shrinking it, see here:

http://support.microsoft.com/default...&Product=sql2k

If you don't need transaction log backups (see "Selecting a Recovery
Model" in BOL), then the simplest option may be to set your database to
the simple recovery model - the log will then be truncated
automatically.

Simon

[Danny]

Just to be clear. Setting the recovery model to 'Simple' will truncate
inactive portions of the log (free space within the file) automatically.
But you will still need shrink the log file at least once to reclaim the
disk space.

"Simon Hayes" <sq*@hayes.ch> wrote in message
news:11**********************@g43g2000cwa.googlegr oups.com...

I don't really understand your first question, but the log is there to
ensure that all changes to the database can be rolled back/forward if
necessary, such as when the server crashes. See "Transaction Logs" in
Books Online. As for shrinking it, see here:

http://support.microsoft.com/default...&Product=sql2k

If you don't need transaction log backups (see "Selecting a Recovery
Model" in BOL), then the simplest option may be to set your database to
the simple recovery model - the log will then be truncated
automatically.

Simon