How edit the ERROR file without shutdown the database

Question

Post reply

How edit the ERROR file without shutdown the database

Wang, KT

SSC Enthusiast

Points: 152
More actions
February 26, 2004 at 2:46 pm

#84044

Are there a way to modify the error log file when SQL server online. I have a monitor to watch my ERROR log file by every 5 mintues. If any error message - Serverity grant then 18. I will get page and e mail. But, I don't want to monitor script page and e mail me all the time. I need to change serverity less than 19.
Please let me know, Thanks

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

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

wz700 SSCertifiable Points: 7133 More actions · Answer 1

sp_cycle_errorlog can be used to avoid modify the errorlog.

Only if error happen a lot, you will lose history.

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 2

why not setup an alert and have sqlagent sending you the mail ?

(check BOL)

There are demo-alerts with sqlserver instaled, but not activated.

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

Wang, KT SSC Enthusiast Points: 152 More actions · Answer 3

Thanks guys for the help.

sp_cycle_errorlog works for me now. I may setup a alert and let sqlagent to taking care of it later. By the way, could you please show me how to check BOL.

Thanks again,

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 4

like BTW = "by the way", BOL stands for "books online"

Start\Programs\Microsoft SQL Server\Books Online

look for "Defining Alerts".