SQL: maintenance plan & copy only Backup option.

Hello Experts,

I have a question related to maintenance plan and copy-only, Backup


2018-07-12-14_37_51-Untitled---Messa.png
Maintenance plan is generated 3 times per day.
I would like to know if selecting this option is the best practice.

I have a recommendation from a colleague that in case of crash and data base recover the backup issued without selecting this option will not be operational, I would like to know if he is correct or not.

Thank you very much for your help.
LVL 1
LD16Asked:
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.

Vitor MontalvãoMSSQL Senior EngineerCommented:
Maintenance plan is generated 3 times per day.
What that means? It should be only generated once in the live of a SQL Server instance. You can then update the maintenance plan as needed or recreate it in case of somebody delete it.

I would like to know if selecting this option is the best practice.
Depends on what you want to do. At least isn't a common practice.

I have a recommendation from a colleague that in case of crash and data base recover the backup issued without selecting this option will not be operational, I would like to know if he is correct or not.
Totally wrong. The Copy Database option is mostly used to take an extra backup of the database without affecting the current backup chain.
0
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.