cancel
Showing results for 
Search instead for 
Did you mean: 

Clear sybase database logs under D:\sybase\BWP\ASE-15_0\install

0 Kudos

Hi gurus,

I'm having a situation where the sybase logs under "D:\sybase\BWP\ASE-15_0\install" were increasing rapidly. Can i just delete the file and will sybase create a new BWP.log again? Please advice.

Thank you.

Regards,

Devan.

Accepted Solutions (1)

Accepted Solutions (1)

former_member188958
Active Contributor
0 Kudos

You can use sp_errorlog to cause ASE to start logging to a new file, then archive or delete the original file.

0 Kudos

Thank you, Bret. Issue resolved!

0 Kudos

I need to clear the data of sybase log, please suggest the exactly command to proceed. Thank you.

Mark_A_Parsons
Active Participant
0 Kudos

Kayasit,

I recommend you ask a new question and provide details of your environment (eg, output from select @@version, details of what 'log' you're trying to clear, etc).

In particular, it's not clear (to me) if you're referring to the OS-level errorlog file (ie, what Bret's talking about) or if you're referring to the transaction log for one of your databases.

Answers (0)