DB crashed

Question

Post reply

DB crashed

shivakumar.623

Grasshopper

Points: 17
More actions
May 14, 2015 at 11:22 pm

#318225

My database was crashed then How to identified in particular server particular database was crashed

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Huh?

Could you perhaps be a little more specific as to what's wrong?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Grant Fritchey SSC Guru Points: 398715 More actions · Answer 2

If you connect to the server using SQL Server Management Studio, you'll see which database is offline or in suspect mode. Otherwise, you can query sys.databases to see the current status of the databases on the server.

Not sure if that's what you're looking for or not.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Jeff Moden SSC Guru Points: 1003894 More actions · Answer 3

shivakumar.623 (5/14/2015)
My database was crashed then How to identified in particular server particular database was crashed

Let's start from the beginning. What are the indications or error messages that you received that your database crashed?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Eirikur Eiriksson SSC Guru Points: 182882 More actions · Answer 4

shivakumar.623 (5/14/2015)
My database was crashed then How to identified in particular server particular database was crashed

Quick question, (and piling on the previous questions) can you tell us what you mean by "crashed"?

😎

Jeff Moden SSC Guru Points: 1003894 More actions · Answer 5

Eirikur Eiriksson (5/16/2015)
shivakumar.623 (5/14/2015)
My database was crashed then How to identified in particular server particular database was crashed
Quick question, (and piling on the previous questions) can you tell us what you mean by "crashed"?
😎

Apparently, it doesn't matter on the weekend. 🙂 Wishing the OP a productive Monday morning. Moving on... 😉

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)