Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

What is database architecture? : SQL Server Architecture

0 Answers  


What command is used to create a database in the sql server and how?

0 Answers  


What are “phantom rows”?

0 Answers  


What is the difference between local table and global table

1 Answers   CarrizalSoft Technologies, Polaris,


what is a self join? Explain it with an example? : Sql server database administration

0 Answers  


What are the steps you can take to avoid “deadlocks”?

0 Answers  


What is tempdb in sql server?

0 Answers  


How to convert numeric expression data types by assignment operations?

0 Answers  


What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security

0 Answers  


What are the differences between sql server and mysql.

0 Answers  


How do you load large data to the SQL server database?

2 Answers  


can primery key be a non clustered index?

10 Answers  


Categories