cancel
Showing results for 
Search instead for 
Did you mean: 

SQL backup query

justjuls
Level 3

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.

1 ACCEPTED SOLUTION

Accepted Solutions

Michal_Mikulik1
Moderator
Moderator
Partner    VIP    Accredited Certified

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.

View solution in original post

2 REPLIES 2

Michal_Mikulik1
Moderator
Moderator
Partner    VIP    Accredited Certified

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.

thank you!