September 22, 2008 at 11:09 am
How do I know if I have enough log space for my databases and system databases? In what mode my databases should be?
September 22, 2008 at 11:32 am
Speaking of which recovery mode, much of that depends on what your responsibilities/ SLAs are for each of the databases you support. If you don't require the ability to do point in time restores, perhaps you can get by with simple. Otherwise you'll need to be in Full or Bulk Logged mode. You can read in BOL about each and what the differences are. You need to figure out how much data loss is acceptable for your environment. Can you lose 5 minutes of data, 5 hours, 5 days?
As for disk space that's another It depends type of question... How big is your DB? How much free space are on your disks? How fast does your database grow? etc.
-Luke.
September 22, 2008 at 11:33 am
Basic rule of thumb for logs is to make them 20% of the database size, then monitor growth and re-size accordingly.
As far as recovery models, the answer is, It Depends. It depends on how active the databases are, how much data you (the business) can afford to lose, what the primary purpose of the database is, and possibly other factors. If you will never need to do a point in time recovery and daily full backups are enough then you should use Simple. If you need to be able to restore to a point in time then you need to be in Full and remember to take regular log backups.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
September 22, 2008 at 11:45 am
I have Data 99MB and Logs 77MB, so you are saying that Logs should be 120MB? Can I change that anytime? Thank you
September 22, 2008 at 12:20 pm
It sounds like your database is in Full recovery and you are not doing TX Log backups. Normally when first creating a database you estimate the space needed for the DB say 100 GB and then allocate 20% of that (20 GB) for log space. If you see your log growing often then you either need to decrease the time between log backups or increase the size of your log.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
September 22, 2008 at 12:47 pm
Yes the db in full mode,but we have transaction logs set up through maintance plan. I am confused should I change the log size? Thank you
September 22, 2008 at 12:58 pm
How often are you running the Transaction Log backups in your maintenance plan? Based on the size of the database and t-log, it doesn't look like your are running it very frequently.
😎
September 22, 2008 at 1:04 pm
Run the log backups on your interval and note the sizes. This will help you figure out how big to size the log. The more often you backup the log files, the smaller your log can be.
For the data, be sure you have enough space to handle growth in your files for a few months. You don't want them to autogrow and you don't want to manage this on a daily basis.
September 22, 2008 at 1:12 pm
Occurs every 1 days at 2:30:00 AM .
September 22, 2008 at 1:14 pm
Sorry, can you explain how?
September 22, 2008 at 1:16 pm
If you are only doing daily log backups you should be in SIMPLE mode. Or, you should be doing TX Log backups on a more frequent basis. I usually start with hourly.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
September 22, 2008 at 1:21 pm
If I do in a simple mode, I can't do transaction logs right?
September 22, 2008 at 1:27 pm
yulichka (9/22/2008)
If I do in a simple mode, I can't do transaction logs right?
That's correct, but you can still do full and differential backups to keep your SLA if it's for instance 4 hours, do a full every night and a diff every 4 hours.
The biggest thing you lose when you switch to simple is point in time restores. You can't get back to the point just before something happened.
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply