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 |
What is database architecture? : SQL Server Architecture
What command is used to create a database in the sql server and how?
What are “phantom rows”?
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
What are the steps you can take to avoid “deadlocks”?
What is tempdb in sql server?
How to convert numeric expression data types by assignment operations?
What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security
What are the differences between sql server and mysql.
How do you load large data to the SQL server database?
can primery key be a non clustered index?
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)