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
Scalability, Availability, Integration with internet, etc.)?
How to make conditional sum in ssrs?
how would you store your query in an SSRS report or a Database server?
What is sql server profiler trace data file?
Where to find ntwdblib.dll version 2000.80.194.0?
What is the difference between mysql and sql server?
When would you use sql joins?
How can you control the amount of free space in your index pages?
How do I create a trace in sql server?
John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?
What is the difference between Triggers and Stored Procedure?
Explain Capacity planning to create a database? and how to monitor it?
What are the aggregate and scalar functions?
How can you ensure that the database and sql server based application perform well?
explain different levels of normalization? : Sql server database administration