March 19, 2014 at 10:51 am
I have a database (Prod) which is about 10 GB and I am supposed to setup a transactional log backup. I know the drill is to take Full once a week and then differential for the rest of the week and then setup Transactional log every 15 minutes to an hour which depends on how much data we are willing to lose in case of disaster.
Question:
Since the DB is small, is it ok if I just take Full backup everyday (No differential backup) and then transactional log every hour? Does it affect anything?
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
March 19, 2014 at 11:05 am
I'm not sure where you got your "drill" information, but in my opinion that'd be the minimum. Ideally, ask the question "how much data am I willing to lose?" - Let's say you have a full backup running on Sunday: early Monday morning there's a "blip" with your disk subsystem, resulting in some data corruption, your take diff's and tlog backups all week long, then the next time you run your database integrity checks (several days later) you find you have corruption and it requires fixes which involve data loss - you could be looking at a really bad day...
For such a small system, I would run a full backup daily, differentials every 4 or 6 hours, and transaction log backups every minute, and would add a DBCC CHECKDB with no info msgs, all error msgs running daily as well (preferably not against the production system, but somewhere nevertheless)
This will hopefully allow you to sleep more sounded at night 😉
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply