Shulou(Shulou.com)05/31 Report--

This article introduces the relevant knowledge of "sql2000 error reporting Successfully re-opened the local eventlog solution". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

Error 1:Unable to read local eventlog (reason: the event log file has been changed between reads. 2:Successfully re-opened the local eventlog-NOTE: Some events may have been missed.

Microsoft explains: http://support.microsoft.com/default.aspx?scid=kb;en-us;811484

Solution:

If you want to prevent error logs, you can use trace flag 2505 as the startup parameter when these messages appear in

To use trace flag 2505 as the SQLServer startup parameter, use the following steps:

1. Enterprise Manager, right-click the server name, and then Properties. two。 On the General tab, click Startup parameters. 3. Add the following as a new parameter:-T2505 4. Restart the server to take effect on the new parameters

After testing, the above changes are easy to cause the sqlserver to fail to start.

The following recovery methods are given:

If the above modification causes sqlserver to fail to start

Look up T2505 through the registry to find this parameter and delete it.

The copy code is as follows:

Windows Registry Editor Version 5.00 [HKEY_LOCAL_MACHINE\ SOFTWARE\ Microsoft\ MSSQLServer\ MSSQLServer\ Parameters] "SQLArg0" = "- dd:\\ database\\ sqlserver\\ MSSQL\\ data\\ master.mdf"SQLArg1" = "- ed:\ database\ sqlserver\\ MSSQL\ log\ ERRORLOG" SQLArg2 = "ld:\\ database\\ sqlserver\\ MSSQL\\ data\ mastlog.ldf" this is the end of the introduction of "sql2000 error Successfully re-opened the local eventlog solution" Thank you for your reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.