Solved

Truncate a Log File

Posted on 2006-11-10
4
3,216 Views
Last Modified: 2008-01-09
I am new to adaptive server anywhere, I have a log file that I want to trunacte is there a tool in sybase central that can do that
0
Comment
Question by:brogrimes
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 

Expert Comment

by:Veneno
ID: 17915151
I don't know if there is such a tool on Sybase Central. But try to run this command while logged to Sybase or on your Database Manager software:

dump tran [database_name] with truncate_only

or

dump tran [database_name] with no_log
0
 
LVL 24

Expert Comment

by:Joe Woodhouse
ID: 17920568
In Sybase Central, right click on the database, you should get an option for Backup/Restore/Dump. (Don't have it in front of me, can't remember the exact menu option.)

You should know that both "dump tran ... with truncate_only" and "... with no_log" will disable all regular transaction (incremental) dumps in a database until a full dump database is done. This can be very important in production databases!

Further, "no_log" has some risks associated with it. You should regard it as last resort, only for when all other versions of "dump tran" fail.
0
 
LVL 3

Expert Comment

by:knel1234
ID: 17973126
Hi,

If you have transactions logs as part of your recovery plan, then I would do the following.  First, dump tran [database name] with truncate_only (Joes suggestion).  Second, immediately dump the database.  Note, until you dump the db you will be at risk for recovery.  You probably should do a little research into why this has occurred.  Long running transaction (was it valid/invalid), developers missing commits, users not committing, etc.

cheers
knel
0
 
LVL 3

Accepted Solution

by:
knel1234 earned 500 total points
ID: 18006214
Hi,

I occurs to me that you asked us about truncating the Log File.  I am think now that you meant the text file that is produce by Sybase for Information and error messages about your running server.  Follow the instructions below to download and install.  Then  in a cmd window run the following
copy srv_log_file.log srv_log_file_archive.log
"tail -1000 srv_log_file.log > srv_log_file_trim.log" - this takes the last (tail) 1000 lines adjust this number as desired
review and make sure you have the information/error messages for the time period you desire
"copy srv_log_file_trim.log srv_log_file.log"

knel


SUMMARY: Display the most recent results of a log file with the tail command for Windows XP.
 
The tail command, on most Unix-style operating systems, lets you display the last 10 or so lines of a text file. It also supports a feature allowing you to keep a file lock on a particular file, displaying new lines as they appear. This is most commonly used for displaying the results of log or debug files, letting you see only the most recent activity of a particular process.

While Windows XP does not normally come with a 'tail' tool, it is available in the Windows 2003 Resource Kit. It is a large download, but besides the 'tail' command, the Windows 2003 Resource Kit also provides tools to remap keys, query the Active Directory, and more. To download and install the Resource Kit:

1. Go to the Microsoft Windows Server 2003 download section at http://www.microsoft.com/windowsserver2003/
downloads/tools/default.mspx. Or, if that link does not work, visit http://www.microsoft.com/ and search for "Windows 2003". Once there, choose the "Downloads -> Tools" link.

2. Select the link "Windows Server 2003 Resource Kit Tools".

3. Click the "Download" link. Choose to register or not, depending on your choice, and follow the on-screen instructions to download and install the product. The default install directory is "C:\Program Files\Windows Resource Kits\Tools\".

Once the Windows 2003 Resource Kit is installed, you may need to reboot your machine for the directory "C:\Program Files\Windows Resource Kits\Tools\" to be added to your path.

Now that the tail command is available, to see the online help, enter the following DOS command:

tail /?
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Sybase initialize new disk in Solaris 10 failed 2 990
SQL Time Syntax 4 316
Crystal Reports VB6 11 1,095
Pivot and Unpivot in Sybase 2 1,780
Dramatic changes are revolutionizing how we build and use technology. Every company is automating, digitizing, and modernizing operations. We need a better, more connected way to work together as teams so we can harness the insights from our system…
This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…
Suggested Courses

710 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question