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?



in my server i have 3 instances,one of them got failed, and this cause we r not able to connect t..

Answer / 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

More SQL Server Interview Questions

Can we store videos inside the sql server table?

0 Answers  


What do you mean by acid?

0 Answers  


What Are Three Rules to UseĀ UNION IN SQL SERVER

1 Answers  


What is purpose of normalization?

0 Answers  


What is a fill factor?

0 Answers  






Explain error and transaction handling in sql server?

0 Answers  


What do you mean by collation recursive stored procedure?

0 Answers  


What is the difference between clustered and a non-clustered index?

0 Answers   NA,


Explain logical operators in sql server?

0 Answers  


What is the maximun sixes of .mdf in sql server 2005

1 Answers  


How to see existing views in ms sql server?

0 Answers  


How to find which stored procedure is currently running in sql server?

0 Answers  


Categories