We may have faced an issue like SQL Server error log is getting filled with entries...!
So, We just want to clear the error log entries.. right ?
Oh.. Wait!
First, Tell me that How to read the entries from my SQL Server Error Log ? (from Active/current file) then we can move into further ...:)
Read SQL Server Error log (Active file)
EXEC master.dbo.xp_readerrorlog 0, 1, NULL, NULL, NULL, NULL, N'desc'
Ok. Then how to write a new entry into the SQL server Error log ?
Log an entry into SQL Server Error log
RAISERROR('SQL Server Buddy',16,1) WITH LOG
Now, Can we go further to clear the log entry ? YES
we can use either...
To clear SQL Server error log
DBCC errorlog
--or
EXEC sp_cycle_errorlog
So, We just want to clear the error log entries.. right ?
Oh.. Wait!
First, Tell me that How to read the entries from my SQL Server Error Log ? (from Active/current file) then we can move into further ...:)
Read SQL Server Error log (Active file)
EXEC master.dbo.xp_readerrorlog 0, 1, NULL, NULL, NULL, NULL, N'desc'
Ok. Then how to write a new entry into the SQL server Error log ?
Log an entry into SQL Server Error log
RAISERROR('SQL Server Buddy',16,1) WITH LOG
Now, Can we go further to clear the log entry ? YES
we can use either...
To clear SQL Server error log
DBCC errorlog
--or
EXEC sp_cycle_errorlog
Very Nice Pandian
ReplyDeleteThanks Veda!
ReplyDelete