Sql server 2008 r2 services won't start

Question

We lost power couple of times and I suspect that the UPS didn't keep the server on. I checked the log and it shows that there were couple unexpected shutdowns. I was try to login to sql server database but It won't let me, so I did some investigation and found that the services path does not exist. For example

the path to the MSSQLSERVER service "D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\BINN\sqlservr.exe" does not exist in the server.

I only see Microsoft SQL Server folder but no MSSQL10_50... I tried to repair using the DVD no luck it keeps failing and says master database is missing in addition to other files.

Any idea how can I fix this problem?

Thank you very much

Is/was your D: partition on a separate set of disks? Did you possibly lose an array? — DanBig, Jul 21 '14 at 13:01

score 0 · Answer 1 · answered Jul 21 '14 at 13:12

0

If you lost your database files, then only a restore will help.
If you did not lose your database files, and only the built-in files are missing, try to restore only those and then go with the repair.

answered Jul 21 '14 at 13:12

MichelZ

11,068
4
32
59

Sql server 2008 r2 services won't start

1 Answers1