SQL Server ErrorLog Error Log description

Source: Internet
Author: User

By default, SQL Server saves seven ErrorLog files named:
ErrorLog
ErrorLog.1
ErrorLog.2
ErrorLog.3
ErrorLog.4
ErrorLog.5
ErrorLog.6
In apacs OS 6.1, The ErrorLog file is saved in the c: \ Program Files \ Microsoft SQL Server \ MSSQL $ WINCC \ LOG folder. In apacs OS 7.0, the ErrorLog file is saved in the c: \ Program Files \ Microsoft SQL Server \ MSSQL.1 \ MSSQL \ LOG folder. The ErrorLog file contains the latest information; The ErrorLog.6 file contains the oldest information.
Each time you restart SQL Server, these log files are in the following cycle:
Delete all data in ErrorLog.6 and create a new ErrorLog file.
All data in the last ErrorLog file is written to the ErrorLog.1 file.
All data in the last ErrorLog.1 file is written to the ErrorLog.2 file.
All data in the last ErrorLog.2 file is written to the ErrorLog.3 file.
All data in the last ErrorLog.3 file is written to the ErrorLog.4 file.
All data in the last ErrorLog.4 file is written to the ErrorLog.5 file.
All data in the last ErrorLog.5 file is written to the ErrorLog.6 file.
If one of the ErrorLog files is large, you can manually cycle these ErrorLog files by running the sp_cycle_errorlog stored procedure. Note: The data in the old ErrorLog file will be overwritten! If you must save the data in the old ErrorLog file, you can copy these old ErrorLog files to an external storage medium.
In apacs OS 6.1, you can use SQL Q
Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.