Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««12345»»»

Database in Recovery mode Expand / Collapse
Author
Message
Posted Tuesday, January 21, 2014 7:34 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 12:53 PM
Points: 54, Visits: 188
Thanks a lot Gail Shaw..

I am very grateful to you.. By the way I am a junior DBA and my Senior DBA resigned. So I am the one has to handle everything.

I will let you the status of my database once it is up. In the mean while i will see the SQL training sites..

Thanks
Praneeth
Post #1533064
Posted Tuesday, January 21, 2014 7:40 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 12:43 PM
Points: 15,663, Visits: 28,061
Since you are completely on your own on this, again, I suggest getting a copy of my book. Links are down in my signature.

After you get backups in place... that has to be priority #1.


----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1533069
Posted Tuesday, January 21, 2014 7:41 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 4:23 AM
Points: 243, Visits: 408
Pluralsight offers (or did when I joined) a free 30 days for video trial courses....they just bought another company (forget the name) and there are now more for the "Pro" membership. I have found both worth the money (I pay it myself) as I do some IT stuff for fun on the side. They have a 8 hour course on "SQL Server: Logging, Recovery, and the Transaction Log" for example....good stuff....
Post #1533070
Posted Tuesday, January 21, 2014 7:45 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 4:23 AM
Points: 243, Visits: 408
Good to see your book is in O'Reiley, Grant! I will have to give it a read. Hard to find good DB books here in Norway in English and it costs a fortune to ship it. http://my.safaribooksonline.com/book/-/9781430242031?bookview=overview
Post #1533080
Posted Tuesday, January 21, 2014 7:53 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 12:53 PM
Points: 54, Visits: 188
Ok thanks a lot
Post #1533090
Posted Tuesday, January 21, 2014 8:31 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 2:03 PM
Points: 21,655, Visits: 15,323
GilaMonster (1/21/2014)
praneethydba (1/21/2014)
Still in Recovery. I am Panic.


Be patient.
The progress gets logged to the error log, check there for estimated time remaining, but note it's often on the low side


Here is an article with a query to check the recovery process.

http://jasonbrimhall.info/2012/06/04/database-in-recovery/

This query can likely help ease some of the anxiety.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1533126
Posted Tuesday, January 21, 2014 8:39 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 11:31 AM
Points: 42,844, Visits: 35,973
SQLRNNR (1/21/2014)
GilaMonster (1/21/2014)
praneethydba (1/21/2014)
Still in Recovery. I am Panic.


Be patient.
The progress gets logged to the error log, check there for estimated time remaining, but note it's often on the low side


Here is an article with a query to check the recovery process.

http://jasonbrimhall.info/2012/06/04/database-in-recovery/

This query can likely help ease some of the anxiety.


I've seen the error log figure count down to about 10 minutes, then jump up to a few hours again. It's not reliable, it's an estimate.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #1533141
Posted Tuesday, January 21, 2014 8:41 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 2:03 PM
Points: 21,655, Visits: 15,323
GilaMonster (1/21/2014)
SQLRNNR (1/21/2014)
GilaMonster (1/21/2014)
praneethydba (1/21/2014)
Still in Recovery. I am Panic.


Be patient.
The progress gets logged to the error log, check there for estimated time remaining, but note it's often on the low side


Here is an article with a query to check the recovery process.

http://jasonbrimhall.info/2012/06/04/database-in-recovery/

This query can likely help ease some of the anxiety.


I've seen the error log figure count down to about 10 minutes, then jump up to a few hours again. It's not reliable, it's an estimate.


Yeah, but getting an estimate is better than not knowing anything, and knowing is half the battle




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1533145
Posted Tuesday, January 21, 2014 9:21 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 1:57 PM
Points: 588, Visits: 901
[b]I will let you the status of my database once it is up.
Has your database finished recovery? If not, what does the estimate (see Jason's post) say? and has it been changing (hopefully going down)?




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
Post #1533214
Posted Tuesday, January 21, 2014 9:39 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 12:53 PM
Points: 54, Visits: 188
HI,

Unfortunately, no records are shown as output...

Thanks
Praneeth
Post #1533235
« Prev Topic | Next Topic »

Add to briefcase «««12345»»»

Permissions Expand / Collapse