in my server i have 3 instances,one of them got failed, and
this cause we r not able to connect to server, how to know
which instance was dameged?
Answer Posted / sarojini makineni
Open SQL Server error log using notepad to know the Process
ID of respective instance of SQLservr.exe and stop such
process alone using Task Manager - (you may better download
procexp.exe to know the pid)
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How to defragment table indexes?
How much space does sql server 2016 take?
What are the ways available in sql server to execute sql statements?
How to call stored procedure using http soap?
What are the reporting services components?
Are resultset updatable?
When should you use an instead of trigger?
What is dbcc command in sql server?
Why functions are used in sql server?
Tell me something about security and sql azure?
what is a mixed extent? : Sql server administration
Do you know query execution plan?
Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio
What is the security model used in sql server 2005?
How to retrieve error messages using mssql_get_last_message()?