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?
- 1 Answers
- 3741 Views
- IBM, I also Faced
- E-Mail Answers
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
Differentiate between ms sql server reporting services vs crystal reports?
Where views are stored in sql server?
Why is replication required on the sql server?
What is explicit cursors?
Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio
How do you use a subquery to find records that exist in one table and do not exist in another?
How to receive output values from stored procedures?
What is normalization and what are the advantages of it?
What stored by the model? : sql server database administration
What is user-defined inline table-valued function?
How to get the number of affected rows?
What authentication modes does sql server support?
What are a scheduled jobs?
Explain external key management in sql server 2008
How can you know if the row fetched from cursor is still valid in underlying table?
