Remove Error logs Sql server

To remove error logs from sql server, we need to execute the command sp_cycle_errorlog on sql server to move the current file as old and create new blank one. Once it is done, we can remove the old files from logs folder. Further we will need to provide us the SA user login to execute the command.

Connect management studio using SA login

New query >> type sp_cycle_errorlog in query window.
Click on run to run/execute to execute the query.

It will delete the old error log files and create a new one.

It will save the space of the sql server.

By anup

Leave a Reply

Your email address will not be published. Required fields are marked *