cancel
Showing results for 
Search instead for 
Did you mean: 

Wildcard Exclude for MSSQL?

William_Jansen_
Level 5
Partner Certified

Hi

We're using NBU 7.5.0.1 and was wondering if it's possible to protect our MSSQL environment with NBU using the $ALL operation but excluding 'restored/test' databases with and Exclude wildcard? In other words in stead of excluding individual databases we were wondering if it's possible to put something like the following in the backup script: "exclude *_RST" or "*_TEST" as all restore/test dabases have the _TEST/_RST appended to it.

Thanks in advance for any input.

Will

1 ACCEPTED SOLUTION

Accepted Solutions

Omar_Villa
Level 6
Employee

Why you dont move this test/dev DB's in to a different Instance in the same SQL box? that will cover the all thing and you can still use the $ALL option.

View solution in original post

2 REPLIES 2

Will_Restore
Level 6

You cannot use wildcard characters in SQL Server exclusion lists.

 

Omar_Villa
Level 6
Employee

Why you dont move this test/dev DB's in to a different Instance in the same SQL box? that will cover the all thing and you can still use the $ALL option.