question

Hussainpatel avatar image
Hussainpatel asked

My server is stopped how can i troubleshoot it......

this is question i faced in interview i said to him,I will start sqlserver service but he was not accepting........ what is the anwser tell me
sql-server-2008interview-questions
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thank you............
0 Likes 0 ·
Grant Fritchey avatar image
Grant Fritchey answered
This was a question to test your knowledge and understanding of the system. There isn't a right or a wrong answer. It's one where we explore what you've seen, how you've been able to troubleshoot issues, failures and successes you've had in the past when dealing with the server being offline. If I were the one interviewing you, I'd say that the server is down, now what? Your answer, just starting the service doesn't take into account determining any issues, testing connectivity, all sorts of things. For example, it's pretty normal to get a report that a SQL Server instance is offline when, in fact, it's fine and the person reporting it doesn't have the right connection string. So just going straight to the service and trying to start it would be a problematic approach if the server was already started.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Dugi avatar image
Dugi answered
It can be many reasons, but the most basic one is when you change your account's password that starts that SQL Server Service! If needed try to check also the events at OS level!
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.