Transaction LOG
This is a discussion on Transaction LOG within the SQL Server Data Warehousing forums, part of the Microsoft SQL Server category; --> Hi guys, I dont know if im in the right group. My scenario is like this. Transaction logs are ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 08:09 PM
| ||||
| ||||
 Transaction LOG 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      |
|
02-27-2008, 08:09 PM
| |||
| |||
| Re: Transaction LOG 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...SQL_server.asp http://support.microsoft.com/kb/873235 http://sqlserver2000.databases.aspfa...ql-server.html here a description of what is the log file: http://www.databasedesign-resource.c...ction-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 |
|
02-27-2008, 08:09 PM
| |||
| |||
| Re: Transaction LOG Hi, Please refer below site for more info. http://www.karaszi.com/SQLServer/default.asp Thanks Ajay "Jeje" <willgart@hotmail.com> wrote in message news:A680E8A0-EB39-447C-8020-DFDCA55736AD@microsoft.com... 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...SQL_server.asp http://support.microsoft.com/kb/873235 http://sqlserver2000.databases.aspfa...ql-server.html here a description of what is the log file: http://www.databasedesign-resource.c...ction-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 |
|
03-28-2008, 05:40 AM
| |||
| |||
| Re: Transaction LOG 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 |
|
04-08-2008, 03:38 PM
| ||||
| ||||
| Re: Transaction LOG Backup the logs and free some space up. MC "Knowledgy" <atlanta business intelligence consultants> wrote in message news:B4udnaU6nPexyHnanZ2dnUVZ_jGdnZ2d@comcast.com. .. 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 |
Linear Mode
