11-19-2013 10:46 PM
I am trying to backup SQL Server Databases , and we are using SQLINSTANCE $ALL in out backup script. Log backups are failing with Status 1 , saying some DBs can't backed up because they are in Simple recovery mode. How to Exclude those DBs from LOG backups.
11-19-2013 11:09 PM
Extract from NBU for SQL Admin Guide:
11-19-2013 11:43 PM
Marianne, I want DBs to be excluded from LOG backups only, I need Incrimental and full backup to run. Will that happen if I exclude DB like this? Is there any way to exclude it from script?
11-19-2013 11:50 PM
Your log backups should be in a separate script with DATABASE $ALL as selection, followed by
EXCLUDE <database> in the script.
So, instead of NB_SQL_DATABASE_EXCLUDE environmental variable, use the EXCLUDE <database> in the script.
11-19-2013 11:56 PM
But I am having multiple instances in server and I don't want to create separate script per Instance. Is there any other way to add multiple instance selection in same script.
11-20-2013 12:04 AM
Have you tried to read through the section in the manual that I have quoted from above?
You can see that it caters for SQLINSTANCE $ALL and DATABASE $ALL.
11-21-2013 06:19 AM
Went through it couple of time, looks like there is no option to exclude a DB in an Instance using the script .
11-21-2013 08:39 AM
So did I.
What I saw was the ability to use 'EXCLUDE <database>' in the script.