Hi guys,

I dont know if im in the right group. My scenario is like this. =
Transaction logs are eating up my server's hard drive. Almost 60% of my =
space is transaction log. What are these? Can I simply delete it? Can I =
compress this? Can someone explain this log file.

Thank you in advance.

you can't delete these files.
the transaction log is truncated when you do a backup.
or you can truncate it:
http://www.codeproject.com/useritems/truncate_log_SQL_server.asp
http://support.microsoft.com/kb/873235
http://sqlserver2000.databases.aspfaq.com/how-do-i-reclaim-space-in-sql-s=
erver.html

here a description of what is the log file:
http://www.databasedesign-resource.com/sql-server-transaction-log.html

and finally the best newsgroup is:
sqlserver.server


[quoted text, click to view]
Hi guys,

I dont know if im in the right group. My scenario is like this. =
Transaction logs are eating up my server's hard drive. Almost 60% of my =
space is transaction log. What are these? Can I simply delete it? Can I =
compress this? Can someone explain this log file.

Thank you in advance.

Hi,
Please refer below site for more info.

http://www.karaszi.com/SQLServer/default.asp

Thanks
Ajay
[quoted text, click to view]
you can't delete these files.
the transaction log is truncated when you do a backup.
or you can truncate it:
http://www.codeproject.com/useritems/truncate_log_SQL_server.asp
http://support.microsoft.com/kb/873235
=
http://sqlserver2000.databases.aspfaq.com/how-do-i-reclaim-space-in-sql-s=
erver.html

here a description of what is the log file:
http://www.databasedesign-resource.com/sql-server-transaction-log.html

and finally the best newsgroup is:
sqlserver.server


[quoted text, click to view]
Hi guys,

I dont know if im in the right group. My scenario is like this. =
Transaction logs are eating up my server's hard drive. Almost 60% of my =
space is transaction log. What are these? Can I simply delete it? Can I =
compress this? Can someone explain this log file.

Thank you in advance.