Thursday, July 05, 2007

Dumping Sybase Transaction Log

A common database problem is transaction logs filling up when the log is not setup to automatically truncate. This can cause all sorts of problems for your database dependent applications. You will have to dump it or you could face serious performance issues. You might consider making your transaction log bigger if automatically truncating the log is not an option.

Here is the syntax.

# isql -Usa -Ppassword
1> use esoftdb
2> go
1> dump tran esoftdb with no_log
2> go

1 comment:

SybaseTeam.com said...

http://www.sybaseteam.com/sybase-transaction-log-how-to-measure-the-growth-t-138.html