Re: Transaction LOG
- From: "MC" <marko.NOSPAMculo@xxxxxxxxx>
- Date: Tue, 8 Apr 2008 07:11:17 +0200
Backup the logs and free some space up.
MC
"Knowledgy" <atlanta business intelligence consultants> wrote in message news:B4udnaU6nPexyHnanZ2dnUVZ_jGdnZ2d@xxxxxxxxxxxxxx
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@xxxxxxxxxxx> wrote in message news:unLkq6wBIHA.4836@xxxxxxxxxxxxxxxxxxxxxxx
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
- Prev by Date: Re: Aggregate when measure contains a specific value
- Next by Date: Re: Storing natural keys in the dimension tables, to aid ETL matching
- Previous by thread: Aggregate when measure contains a specific value
- Next by thread: Re: Get data from olap dw back to the operational db
- Index(es):
Relevant Pages
|
