Truncate a Log File

Posted on 2006-11-10
Medium Priority
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
Question by:brogrimes
  • 2

Expert Comment

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


dump tran [database_name] with no_log
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.

Expert Comment

ID: 17973126

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.


Accepted Solution

knel1234 earned 1500 total points
ID: 18006214

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"


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 /?

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Are you wondering how to check data usages on your T-Mobile? Here are the quick ways to check data usages or balance on T-Mobile.
When the first reports of the initial sales of Nintendo Switch in the Land of the Rising Sun appeared. In Japan, only 330,637 consoles were sold for the first day. But many large retail chains have already sold out the entire edition of the console …
In this video I will demonstrate how to set up Nine, which I now consider the best alternative email app to Touchdown.
Watch the video to know the simple way to remove or recover or reset lost or forgotten passwords of Outlook PST file. With Kernel Outlook Password Recovery tool such operation is very easy to perform. It is a freeware with limitation to use with 500…

624 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