SQL Server Logs

Question

SQL Server Logs

Viewing 4 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 739541 More actions · Answer 1

You can periodically cycle the logs without rebooting. sp_cycle_errorlog or something like that will work. I had a server that never went down and we had the same issue, so we cycled them every week.

Rudyx - the Doctor SSC-Forever Points: 43695 More actions · Answer 2

To cut directly to the chase:

use master

go

dbcc errorlog

go

checkpoint

go

It works well as a scheduled task.

RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

gjwg Mr or Mrs. 500 Points: 504 More actions · Answer 3

Thanks rudy

Brilliant - I'll shall apply a scheduled task to all our SQL Servers on a period base

philcart SSC-Forever Points: 47797 More actions · Answer 4

We've got something along the lines of what Steve is suggesting. However, the stored proc that does this renames the log file so it doesn't get automatically removed.

--------------------
Colt 45 - the original point and click interface