Overview

This article provides scenario-based options to exclude specific databases from an SQL instance backup.

Exclude database from an SQL instance backup

Refer the scenarios below for the appropriate exclusion.

Databases on SQL instance:

Scenario-1: Exclude contains “v” (lower case v) – Case sensitive

Result = Excludes all the databases which has small case ‘v’ at any place in the database name.
‘Database-mnvp’ and ‘vishal test’ was excluded.

Scenarios-2: Exclude contains “V” (Upper Case V)

Result = Excludes all the databases which has Upper case ‘V’ at any place in the database name.
‘Vishal-DR’ and ‘Vishal-Test’ and ‘Vishal-Standalone’ was excluded.

Scenario-3: Exclude contains “v* or Vis* or v”

Result = This type of exclusion is not valid and will not apply.
Does not exclude any database.

Scenario-4: Exclude contains “vishal- or vish,al or vish!al” (Contains hyphen or underscore)

Result = Database name with all the above will get excluded.
‘vishal-‘ will get excluded at any place in the database name.