tisacson Posted February 6, 2009 Report Share Posted February 6, 2009 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. Quote Link to comment Share on other sites More sharing options...
emulator Posted March 17, 2009 Report Share Posted March 17, 2009 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.