Database in Recovery mode

Question

Database in Recovery mode

Viewing 15 posts - 16 through 30 (of 42 total)

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

praneethydba SSC-Addicted Points: 498 More actions · Answer 1

HI Gail Shaw

They hired me to do this job. As I am in the beginning of my career. I am not sure, from where to start and what to find. But I dont want to give up. I am seeking help from you guys, where I will get some tips on performance tuning and where I can build myself on this project..

Can you please share me the information on partitions, tuning etc...

Thanks

Praneeth

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

praneethydba (1/21/2014)
They hired me to do this job. As I am in the beginning of my career. I am not sure, from where to start and what to find.

Do they know that, or do they think you're an experienced DBA?

If the former, tell them you don't know where to start or what to look for and that they should get an experienced consultant in to do an analysis and recommendations. If the latter, well....

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

tim_harkin SSCrazy Points: 2399 More actions · Answer 3

Don't even think about partitioning. If you do not have backup, partitioning is way over your head (not trying to know you, but if you have no backups, indexes, etc., partitioning is the least of your problems).

Once the dust settles, get a valid backup strategy in place. DBAs get fired for not having valid backups. If your company says they can not afford the space\resources to backup the data, then fight them. Get it in writing all the way up to the CIO level. Make sure that they know, without ANY doubt, that one bad disk sector can take out the entire database. And disks fail, or sometimes hiccup to the point where a database can be corrupted.

Take a look here: http://www.brentozar.com/needs/

praneethydba SSC-Addicted Points: 498 More actions · Answer 4

Ok Sure... After this Incident my boss asked me to configure the backup startegy and DR setup aswell...

Thanks

Praneeth

david.john.gilligan Default port Points: 1471 More actions · Answer 5

I would recommend, among other free sites like here, that you pay for good training ones like pluralsight and O'Reiley books on-line. I saw, for example, they have over 55 training sessions on different aspects (and versions) of SQL Server. And no, I don't own stock in any of them :crying:

praneethydba SSC-Addicted Points: 498 More actions · Answer 6

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

Grant Fritchey SSC Guru Points: 398908 More actions · Answer 7

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

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

david.john.gilligan Default port Points: 1471 More actions · Answer 8

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....

david.john.gilligan Default port Points: 1471 More actions · Answer 9

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

praneethydba SSC-Addicted Points: 498 More actions · Answer 10

praneethydba

SSC-Addicted

Points: 498

January 21, 2014 at 7:53 am

#1681929

Ok thanks a lot

SQLRNNR SSC Guru Points: 281334 More actions · Answer 11

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, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

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

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, 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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 13

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, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Keith Tate SSCrazy Eights Points: 9938 More actions · Answer 14

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[/url]

praneethydba SSC-Addicted Points: 498 More actions · Answer 15

HI,

Unfortunately, no records are shown as output...

Thanks

Praneeth