fault Environment: Winnt4.0cluster+sql Server7.0
<?xml:namespace prefix = o ns = "Urn:schemas-microsoft-com:office:office"/>
Fault description : discovery of the library at about 8:30, cluster SQL Server does not work, look at the Windows log, there are the following error recording
Event Type: Bugs
Event Source: CLUSSVC
Event Categories: (2052)
Event Knowledge: 1066
Date: <?xml:namespace prefix = st1 ns = "Urn:schemas-microsoft-com:office:smarttags"/>2005-1-21
Hours: 8:23:20
User: N/A
Computer: TEST
Describe:
Cluster Disk resource Disk G:: Is corrupt. Running chkdsk/f to repair problems.
Please check the http://go.microsoft.com/fwlink/events.asp and Support Center for additional information.
Depending on the error record, you need to check disk for test/g. After you complete backup of the repository, stop the Cluster service, and after you restart the server, CHKDSK G:/F performs successfully. Activating SQL Server again, Windows Event log out of the following bugs
Event types: Information
Event Source: Mssqlserver$test
Event Categories: Server
Event Knowledge: 17055
Date: 2005-1-21
Hours: 8:23:54
User: N/A
Computer: TEST
Describe:
17052:D atabase ' tempdb ' cannot be opened. It has been marked suspect by recovery. The SQL Server errorlog for more information.
Please check the http://go.microsoft.com/fwlink/events.asp and Support Center for additional information.
Data:
0000:9c 0a B ......
...
0030:00 00.
Looking for 17055,10752 's wrong code at the Microsoft site doesn't have a consequence. Through the lookup keyword "Database ' tempdb ' cannot be opened", find an article rebuilding tempdb http://support.microsoft.com/default.aspx?scid=kb;en-us ; 288809
Processing Methods : According to the Microsoft file, the following steps are provided
1. Configure SQL Server Virtul server Name
C:/> Set _cluster_network_name=yoursqlvirtualname
2. command line to activate SQL Server user mode (command line Windows cannot be closed)
C:/> sqlservr-c-f-t3608-t4022
3. Open the Inquiry Analyzer, log in as SA, execute system save process reset tempdb state
EXEC master.. Sp_resetstatus Tempdb
4. Press CTRL + C to close the 2nd step of the Command line window
5. Reboot the SQL Server, which will automatically rebuild the tempdb
6. The original 1th step of the Environment parameters setup
C:/> Set _cluster_network_name=
At this point, the data library is restored to normal.