Backup Schedule

Question

Post reply

Backup Schedule

PJ_SQL

SSCertifiable

Points: 6703
More actions
October 14, 2022 at 11:34 am

#4099561

Hi!
I need to schedule backup on each Friday and need to keep 4 backups.
We are using ola hallengren script, what should be the retention for this requirement?

Thanks in advance.
October 16, 2022 at 6:33 am

This was removed by the editor as SPAM

Viewing 5 posts - 1 through 4 (of 4 total)

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

ratbak Ten Centuries Points: 1358 More actions · Answer 1

@CleanupTime is in hours. Four weeks is 672 hours.

Grant Fritchey SSC Guru Points: 398882 More actions · Answer 2

There are probably an infinite number of ways to schedule a backup. However, most people will use SQL Agent, which is built right into SQL Server instances (assuming you're not running Express, in which case, do a search for scheduling tools, some are built into the OS, some are easily downloaded for free).

"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

Jeff Moden SSC Guru Points: 1004354 More actions · Answer 3

PJ_SQL wrote:

Hi!
I need to schedule backup on each Friday and need to keep 4 backups.
We are using ola hallengren script, what should be the retention for this requirement?
Thanks in advance.

Have you checked to see if you have room for FIVE backups plus growth for the future? And what of the Transaction Log/Diff backups? Do you have room for FIVE sets plus growth?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)