SQL backup query
Hello,
Is there any simpler way to exclude all simple recovery model DB’s instead of excluding them one at a time in the script? It could be a tedious process to modify each DB’s from the multiple script.
Thanks for help.
I presume you need it for errorless transaction log backups. Then you should switch from script-based MSSQL policies to Intelligent policies, they will omit these DBs automatically during log backups.
Refer to MSSQL Admin Guide for more details.
regards
M.
