05-01-2019 09:04 AM
I am trying to figure out how to add an exclude list to an MS-SQL-Server Policy. The Backup Selection List is WHOLE_DATABASE with multiple instances and the Database Name directive of $ALL (I know I can manually select which databases to backup but I don't want to be responsible if a new database is added to the environment and it isn't added to the selection list).
Any help will be greatly appreciated.
The master server is running 7.7.3 on Solaris 11, the media server is also 7.7.3 running on Solaris 11 and the client is running 7.7.3 on Windows 2012 and the Windows 2016 edition of MSSQL.
Solved! Go to Solution.
05-02-2019 07:20 PM
The SQL Intelligent Policy feature can only back up Instances or individual databases but does not allow exclusions. For exclusions you have to use batch files.
05-01-2019 09:00 PM
There are two ways of doing it, check this technote out https://www.veritas.com/support/en_US/doc/17221771-126559330-0/v14761897-126559330
05-01-2019 11:24 PM
Note that you will have to use legacy script based policies, not intelligent policies. They dont provide exclusions.
Regards
Michal
05-02-2019 05:45 AM - edited 05-02-2019 05:47 AM
Mikhail and Michal,
Thank you for the information. I missed this when looking at the guide.
So is there anyway to do the same thing using intelligent policies?
Regards,
Herb
05-02-2019 07:20 PM
The SQL Intelligent Policy feature can only back up Instances or individual databases but does not allow exclusions. For exclusions you have to use batch files.