Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / General / Data Warehousing / April 2008

Tip: Looking for answers? Try searching our database.

Transaction LOG

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Allan M. Grafil - 05 Oct 2007 06:18 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.