I have 25 production databases that running on Full recovery mode.
Someone changed from Full to Simple recovery mode and he believed the full recovery mode and log backups will use a lot of I/O.
He also believed that the log backup will contribute to a high I/O on SQL Server.
I’m not hundred percent sure but I did not agree with him.
I try to clarify in simple term the different Full and Simple recovery mode.
Full recovery mode –> allows the database to be recovery point of time.
Simple recovery mode –> There are no log backup and possible data lost in case of database corruptions or failing.
And, I recommended to setup maintenance jobs like
— Full User database backup —> Every Sunday at 1am
— Differential User database backup –> Monday – Saturday at 1am
–Log backup –> Daily every 1 hour
Would someone clarify on high I/O usage on T-Log backup and database Full Recovery mode?
It’s that true?
Thank you in advance.