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.
Allan M. Grafil
Jeje - 05 Oct 2007 12:27 GMT
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-server.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
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.
Allan M. Grafil
Ajay - 13 Oct 2007 08:29 GMT
Hi,
Please refer below site for more info.
http://www.karaszi.com/SQLServer/default.asp
Thanks
Ajay
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-server.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
"Allan M. Grafil" <agrafil@hotmail.com> wrote in message news:unLkq6wBIHA.4836@TK2MSFTNGP06.phx.gbl...
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.
Allan M. Grafil
Knowledgy - 22 Mar 2008 01:39 GMT
You can also create a process that uses the DBCC commands to periodically (run it as a job) check the transaction log file sizes and, if past a pre-determined threshhold automatically do a back up or just the truncate by itself to free up space. This will also prevent the database from going down because the transaction log file is full
Sincerely,
John K
Knowledgy Consulting
http://knowledgy.org/
Atlanta's Business Intelligence and Data Warehouse Experts
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.
Allan M. Grafil
MC - 08 Apr 2008 06:11 GMT
Backup the logs and free some space up.
MC
You can also create a process that uses the DBCC commands to periodically (run it as a job) check the transaction log file sizes and, if past a pre-determined threshhold automatically do a back up or just the truncate by itself to free up space. This will also prevent the database from going down because the transaction log file is full
Sincerely,
John K
Knowledgy Consulting
http://knowledgy.org/
Atlanta's Business Intelligence and Data Warehouse Experts
"Allan M. Grafil" <agrafil@hotmail.com> wrote in message news:unLkq6wBIHA.4836@TK2MSFTNGP06.phx.gbl...
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.
Allan M. Grafil