Stop particular event logging in SQL Server errorlog

Question

Post reply

Stop particular event logging in SQL Server errorlog

Kumar-386306

Default port

Points: 1464
More actions
June 18, 2013 at 12:19 am

#294781

Hi,
I need to stop a particular event "Error: 1105, Severity: 17, State: 2.
Could not allocate space for object 'dbo.XXX'.'XXXXX' in database 'XXXXX' because the 'PRIMARY' filegroup is full
" writing in SQL SErver errorlog.
Could you please let me know with the trace number which I need to use to stop the warning writing in SQL Server errorlog?

Viewing 9 posts - 1 through 8 (of 8 total)

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

sharath.chalamgari SSCertifiable Points: 5680 More actions · Answer 1

I am not sure if this could be sort of any help for you

http://msdn.microsoft.com/en-us/library/ms188396.aspx

Kumar-386306 Default port Points: 1464 More actions · Answer 2

Thanks for your reply. However I had reviewed this article before itself. but it doesn't list the trace number which need to used to this particular event

SQL Show SSCertifiable Points: 6143 More actions · Answer 3

SQL Show

SSCertifiable

Points: 6143

June 18, 2013 at 2:50 am

#1624904

sp_altermessage 1105 , 'with_log' , 'false'

Kumar-386306 Default port Points: 1464 More actions · Answer 4

Perfect, it worked now. But to take the setting apply we need to restart the SQL SErver service

Appreciate your help

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

Why hide the fact that the error is occuring? Wouldn't fixing the error be a better solution?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Kumar-386306 Default port Points: 1464 More actions · Answer 6

It's for one of our local old dev servers to cut short the sql error log growth.. I dont want to do it prod server

SQL Show SSCertifiable Points: 6143 More actions · Answer 7

I am testing it without restarting service.It seems working. weired.

Kumar-386306 Default port Points: 1464 More actions · Answer 8

I tested it in SQL Server 2008R2 dev edition, may I changed the setting in the same query analyzer. I'll try with different server after changing the setting with new query window... and keep you posted

Stop particular event logging in SQL Server errorlog

Cookies on SQLServerCentral