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 to encrypt data between dialogs?
can a database be shrunk to 0 bytes, if not, why? : Sql server administration
How to create an multi-statement table-valued function?
What is the difference between a clustered index and a non-clustered index?
How do you troubleshoot SQL Server if its running very slow?
What is spid in sql server profiler?
How do I start sql server 2016?
What is application role in sql server database security? : sql server security
What are the types of table?
How to write character string constants or literals in ms sql server?
How would you retrieve Unique rows from table without using UNIQUE and DISTINCT keyword?
Define the term DML, DDL and DTL?
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)