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.\


Rename the folder "DATA". You can simply rename it "DATA.old".



Create a new folder in this directory named "DATA"



Open the "Template Data" folder and copy all of the files in this directory.



Paste the copy of these files into the newly created C:\Program Files\Microsoft SQL Server\MSSQL10_50."INSTANCE NAME"\MSSQL. folder



Go to SQL Server Configuration Manager and try to start the SQL Server Service again, it should start now.

Post a Comment

Previous Post Next Post