SQL Server log processing and secure access

1, point SQL Server error log, right-click, configure, limit the number of error logs, such as 6 limit log growth

2. Then run the command:

EXEC Sp_cycle_errorlog;

The purpose of this command is to archive the current log, and then create a new log. Because the number of logs is limited to 6, the old log is recycled as long as you run the step several times. Once the SQL service restarts, the log archive is also created, but this command does not have to be restarted.

3, the default port of SQL must be changed

4, sa password must be set strong enough.

SQL Server log processing and secure access