Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Stop particular event logging in SQL Server errorlog Expand / Collapse
Author
Message
Posted Tuesday, June 18, 2013 12:19 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, August 26, 2013 3:12 AM
Points: 233, Visits: 246
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?

Post #1464464
Posted Tuesday, June 18, 2013 12:41 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 3:33 AM
Points: 1,128, Visits: 756
I am not sure if this could be sort of any help for you

http://msdn.microsoft.com/en-us/library/ms188396.aspx
Post #1464470
Posted Tuesday, June 18, 2013 12:51 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, August 26, 2013 3:12 AM
Points: 233, Visits: 246
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
Post #1464472
Posted Tuesday, June 18, 2013 2:50 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, March 21, 2014 9:46 AM
Points: 387, Visits: 1,078
sp_altermessage 1105 , 'with_log' , 'false'
Post #1464509
Posted Tuesday, June 18, 2013 3:03 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, August 26, 2013 3:12 AM
Points: 233, Visits: 246
Perfect, it worked now. But to take the setting apply we need to restart the SQL SErver service :)

Appreciate your help
Post #1464518
Posted Tuesday, June 18, 2013 3:23 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 7:05 AM
Points: 41,532, Visits: 34,449
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 2008, MVP
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

Post #1464528
Posted Tuesday, June 18, 2013 3:26 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, August 26, 2013 3:12 AM
Points: 233, Visits: 246
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 :)
Post #1464529
Posted Tuesday, June 18, 2013 5:09 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, March 21, 2014 9:46 AM
Points: 387, Visits: 1,078
I am testing it without restarting service.It seems working. weired.
Post #1464568
Posted Tuesday, June 18, 2013 10:12 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, August 26, 2013 3:12 AM
Points: 233, Visits: 246
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
Post #1464769
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse