Full recovery model

Question

Full recovery model

Viewing 6 posts - 16 through 20 (of 20 total)

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

Krasavita SSC-Insane Points: 23138 More actions · Answer 1

I am confused, do I have it right or not, if I don't can you please right it execly I need it.Thank you

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 2

I'm not going to tell you how to setup your databases. You need to make a decision on how you want it based on the input you have been given.

You have been given plenty of information, now the rest is up to you.

Krasavita SSC-Insane Points: 23138 More actions · Answer 3

You don't have too, I don't have enough information. It is confusing to me, the way you explainning.

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

There are no hard and fast rules for this. We can't say that your config is right or wrong.

Recommended practices:

Monitor the size of the DB and manually grow it as necessary.

Leave Autogrow on just in case the DB needs to grow unexpectedly

Set the autogrow to a fixed size, not a percentage

Ensure that the autogrow amount is not too small. Too small being where lots of autogrow events would happen if the DB needed to grow

Ensure that the autogrow amount is not too large. Too large being a size that will take long to happen on your system, time out or impact performance

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

Krasavita SSC-Insane Points: 23138 More actions · Answer 5

Thank you it make sense,just make sure I understand corectly: Is for data and logs the same?

For the data:

EnableAutoGrowth set to true

FileGrowth

In Megabytes 100

In Maximum

Unrestricted File Growth

For the log: