Process fault Environment: Winnt4.0cluster+sql Server7.0
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: 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 00 00 00? 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 method: According to the software file, the operation steps are as follows
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.
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.
