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
Explain the concepts and capabilities of sql server?
How to find the login name linked to a given user name?
What is trigger and different types of Triggers?
explain different types of joins? : Sql server database administration
What is similarity and difference between truncate and delete in sql?
How to trouble shoot if unable to connect SQL Server
When a primary key constraint is included in a table, what other constraints does this imply?
What is the importance of three tier architecture?
How to recover from sql injection? : sql server security
Define views.
Is it possible to replicate data from sql server to oracle? : sql server replication
What is reference section?
What is sql server database?
What is the difference between a local and a global temporary table?
Explain about nested stored procedure?