create procedure of automatic backup plan with delete old backup with check condition

Question

Post reply

create procedure of automatic backup plan with delete old backup with check condition

wasim.ahmad780

SSC Veteran

Points: 289
More actions
April 21, 2017 at 5:23 am

#337330

Hi All, we need help regarding the backup plan strategy. we want to create a procedure where in schedule a weekly backup plan and delete old backup but with check condition. once the backup is successful completed then delete old backup otherwise don't delete the old backup. how to use with check condition

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

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

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 1

Use Ola Hallengren's solution. Thousands already do, so it's very robust.

John

Thomas Rushton SSC-Insane Points: 22649 More actions · Answer 2

John Mitchell-245523 - Friday, April 21, 2017 5:31 AM
Use Ola Hallengren's solution. Thousands already do, so it's very robust.
John

+1. https://ola.hallengren.com/

Thomas Rushton
blog: https://thelonedba.wordpress.com

wasim.ahmad780 SSC Veteran Points: 289 More actions · Answer 3

ThomasRushton - Friday, April 21, 2017 6:19 AM
John Mitchell-245523 - Friday, April 21, 2017 5:31 AM
Use Ola Hallengren's solution. Thousands already do, so it's very robust.
John
+1. https://ola.hallengren.com/

Thanks,

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

I'd also consider taking a look at Minion Backup. It does quite a bit of stuff that Ola's scripts do not.

"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