The Request Failed Or The Service Did Not Respond In A Timely Fashion. Consult The Event Log Or Other Applicable Error Logs For Details Error When Starting SQL Server Instance
This error is commonly caused by the Master database in SQL Server being corrupted. There is a copy of these files that can be used to rebuild them.
1 First open a Windows Explorer and go to the folder C:\Program Files\Microsoft SQL Server\MSSQL10_50."INSTANCE NAME"\MSSQL.\
2 Rename the folder "DATA". You can simply rename it "DATA.old".
3 Create a new folder in this directory named "DATA"
4 Open the "Template Data" folder and copy all of the files in this directory.
5 Paste the copy of these files into the newly created C:\Program Files\Microsoft SQL Server\MSSQL10_50."INSTANCE NAME"\MSSQL. folder
6 Go to SQL Server Configuration Manager and try to start the SQL Server Service again, it should start now.
0 Comments:
Post a Comment
Subscribe to Post Comments [Atom]
<< Home