Database in Recovery mode

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  January 21, 2014 at 9:44 am

  #1682067

  The status is RECOVERING? Not anything else?

  Post the error log?

  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

• Keith Tate

  SSCrazy Eights

  Points: 9938

  More actions

  January 21, 2014 at 9:44 am

  #1682068

  What is the output of this code (change the database name):SELECT state_desc

  FROM sys.databases

  where name = 'DatabaseName'

  ---

  
  Microsoft Certified Master - SQL Server 2008
  Follow me on twitter: @keith_tate

  Forum Etiquette: How to post data/code on a forum to get the best help[/url]

• praneethydba

  SSC-Addicted

  Points: 498

  More actions

  January 22, 2014 at 7:25 am

  #1682391

  HI,

  I am happy to tell you, my database is up now.....

  Online now.....:-)

  Thanks a lot for your support...

  Thanks

  Praneeth

• SQLRNNR

  SSC Guru

  Points: 281334

  More actions

  January 22, 2014 at 7:27 am

  #1682394

  That's good news. Glad it is working for you now.

  Jason...AKA CirqueDeSQLeil
  _______________________________________________
  I have given a name to my pain...MCM SQL Server, MVP
  SQL RNNR
  Posting Performance Based Questions - Gail Shaw[/url]
  Learn Extended Events

• praneethydba

  SSC-Addicted

  Points: 498

  More actions

  January 22, 2014 at 7:33 am

  #1682401

  🙂 i am really tensed of my Job...

  I got my database and job back 🙂

• Grant Fritchey

  SSC Guru

  Points: 398909

  More actions

  January 22, 2014 at 8:19 am

  #1682431

  praneethydba (1/22/2014)

  ---

  HI,

  I am happy to tell you, my database is up now.....

  Online now.....:-)

  Thanks a lot for your support...

  Thanks

  Praneeth

  Congrats! That's great!

  Now, run a backup.

  "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

• SQLRNNR

  SSC Guru

  Points: 281334

  More actions

  January 22, 2014 at 8:21 am

  #1682434

  Grant Fritchey (1/22/2014)

  ---

  praneethydba (1/22/2014)

  ---

  HI,

  I am happy to tell you, my database is up now.....

  Online now.....:-)

  Thanks a lot for your support...

  Thanks

  Praneeth

  Congrats! That's great!

  Now, run a backup.

  No, schedule regular backups and make sure they complete successfully.

  Jason...AKA CirqueDeSQLeil
  _______________________________________________
  I have given a name to my pain...MCM SQL Server, MVP
  SQL RNNR
  Posting Performance Based Questions - Gail Shaw[/url]
  Learn Extended Events

• tim_harkin

  SSCrazy

  Points: 2399

  More actions

  January 22, 2014 at 8:25 am

  #1682441

  Good news!

  I would document the incident, including timelines. The time that the database was offline has an associated cost. That is what you need to use when someone says that they can not afford hardware resources for backups.

  Backups are insurance - you have a risk (losing data). To reduce that risk, you pay a premium (the costs of setting up the backups). And you hope that you never make a claim (database failure) but you sleep better at night knowing that you have managed the risk.

  Good luck!

• Keith Tate

  SSCrazy Eights

  Points: 9938

  More actions

  January 22, 2014 at 8:27 am

  #1682444

  SQLRNNR (1/22/2014)

  ---

  Grant Fritchey (1/22/2014)

  ---

  praneethydba (1/22/2014)

  ---

  HI,

  I am happy to tell you, my database is up now.....

  Online now.....:-)

  Thanks a lot for your support...

  Thanks

  Praneeth

  Congrats! That's great!

  Now, run a backup.

  No, schedule regular backups and make sure they complete successfully.

  Also get training resources for yourself and the developer that wrote the code to start a 24 hour transaction that never completed 😀

  ---

  
  Microsoft Certified Master - SQL Server 2008
  Follow me on twitter: @keith_tate

  Forum Etiquette: How to post data/code on a forum to get the best help[/url]

• praneethydba

  SSC-Addicted

  Points: 498

  More actions

  January 22, 2014 at 8:45 am

  #1682459

  Ok Sure..Thanks

• Grant Fritchey

  SSC Guru

  Points: 398909

  More actions

  January 22, 2014 at 9:01 am

  #1682466

  SQLRNNR (1/22/2014)

  ---

  Grant Fritchey (1/22/2014)

  ---

  praneethydba (1/22/2014)

  ---

  HI,

  I am happy to tell you, my database is up now.....

  Online now.....:-)

  Thanks a lot for your support...

  Thanks

  Praneeth

  Congrats! That's great!

  Now, run a backup.

  No, schedule regular backups and make sure they complete successfully.

  Absolutely. Right after you take one manually out of shear paranoia.

  "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

• Michael L John

  One Orange Chip

  Points: 27060

  More actions

  January 22, 2014 at 9:20 am

  #1682477

  Grant Fritchey (1/22/2014)

  ---

  SQLRNNR (1/22/2014)

  ---

  Grant Fritchey (1/22/2014)

  ---

  praneethydba (1/22/2014)

  ---

  HI,

  I am happy to tell you, my database is up now.....

  Online now.....:-)

  Thanks a lot for your support...

  Thanks

  Praneeth

  Congrats! That's great!

  Now, run a backup.

  No, schedule regular backups and make sure they complete successfully.

  Absolutely. Right after you take one manually out of shear paranoia.

  Do all of the above, test the restore, and then get the developers out of the production databases!

  Michael L John
  If you assassinate a DBA, would you pull a trigger?
  To properly post on a forum:
  http://www.sqlservercentral.com/articles/61537/

• SQLRNNR

  SSC Guru

  Points: 281334

  More actions

  January 22, 2014 at 9:23 am

  #1682479

  Michael L John (1/22/2014)

  ---

  Grant Fritchey (1/22/2014)

  ---

  SQLRNNR (1/22/2014)

  ---

  Grant Fritchey (1/22/2014)

  ---

  praneethydba (1/22/2014)

  ---

  HI,

  I am happy to tell you, my database is up now.....

  Online now.....:-)

  Thanks a lot for your support...

  Thanks

  Praneeth

  Congrats! That's great!

  Now, run a backup.

  No, schedule regular backups and make sure they complete successfully.

  Absolutely. Right after you take one manually out of shear paranoia.

  Do all of the above, test the restore, and then get the developers out of the production databases!

  All very sound advice:-D

  Jason...AKA CirqueDeSQLeil
  _______________________________________________
  I have given a name to my pain...MCM SQL Server, MVP
  SQL RNNR
  Posting Performance Based Questions - Gail Shaw[/url]
  Learn Extended Events