Jump to content
tisacson

SQL master database exclude from log script

Recommended Posts

Is it possible to exclude the master database from an SQL Log backup script?

 

For the Source I want to add the full SQL Server so that any new databases are automatically included in the backup. However this will include the master database which will produce an error saying only Full backups can be performed of the master database. Using the exclude selector appears to be ignored as indicated in the documentation for SQL backups.

Share this post


Link to post
Share on other sites

I ran into this problem, and corrected it by creating two "Groups" in the "Volumes" section. One group contains the the "System" databases (Master, Model, and MSDB), and the other contains Full Recovery databases. I perform log backups on the Full Recovery Databases, and perform full backups on the system databases.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×