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.
Post a Comment