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.