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?

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


Please Help Members By Posting Answers For Below Questions

Scalability, Availability, Integration with internet, etc.)?

2932


How to make conditional sum in ssrs?

183


how would you store your query in an SSRS report or a Database server?

165


What is sql server profiler trace data file?

1177


Where to find ntwdblib.dll version 2000.80.194.0?

1007


What is the difference between mysql and sql server?

1087


When would you use sql joins?

1026


How can you control the amount of free space in your index pages?

1100


How do I create a trace in sql server?

1089


John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?

982


What is the difference between Triggers and Stored Procedure?

1152


Explain Capacity planning to create a database? and how to monitor it?

4243


What are the aggregate and scalar functions?

1129


How can you ensure that the database and sql server based application perform well?

1120


explain different levels of normalization? : Sql server database administration

1049