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 / 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 |
How do I determine how many instances of sql server are installed on a computer?
What is the simplest way to create a new database in ms sql server?
How to handle error or exception in sql?
Explain data warehousing in sql server?
How to enter unicode character string literals in ms sql server?
What is INTVAL( )and where we use Plz any body help me
What is the synonym of join?
How To Find That One Week Change in My DataBase we Have Done Like We Have A database Test I Change Table,Stored Procd. Then I Find Which SP,Table We Have Edit/Change in Seven Dayes
In which year relase the 7.0& 2000 & 2005?
Can you tell me about the concept of ER diagrams?
Can you leave a union at any time?
what is a live lock? : Sql server database administration
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)