SQL Server Database Backups

Hi All

I would like to clarify a few things regarding backing up of database.

Our HR application is configured to connect to the production database within an instance.
We run SQL Server 2012 with Always-on High availability configured.

I’d like to clarify a few things please

At the moment we have transaction log backups of the database every 15 minutes. Can we increase this frequency to 15 minutes?
At the moment we also have full backups of the database every night. Can we increase this frequency to twice daily?

In terms of computing resources we have plenty so that’s not a problem, however our DBA disagrees.

Thoughts?
DynamicTanAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Lee SavidgeCommented:
If the logs are backed up already every 15 minutes, what do you want to increase the frequency to? There is no reason why you couldn't do twice daily. It might be better to do a full back up once a day and hourly incremental backups and then do the transaction log every 15 minutes if you want that kind of granularity.
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
At the moment we have transaction log backups of the database every 15 minutes. Can we increase this frequency to 15 minutes?
Increase TO or increase ON? It's already running every 15 minutes as you wrote.

At the moment we also have full backups of the database every night. Can we increase this frequency to twice daily?
Answer for this question is the same as the above one. Yes, you can. You can do even every minute if you want. There's no rule only good sense.

In terms of computing resources we have plenty so that’s not a problem, however our DBA disagrees.
Ah, the DBAs. Always guys full of good sense :)

The backup up plan should met the application requirements. A full database can impact the performance of a database so it's usually runs by night and weekends. You're missing differential backups in your plan and may be the only thing that you can introduce in your current backup plan so would reduce the number of transaction log restores that you'll need when you want to recover the database.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.