Search <book_title>...

Veritas NetBackup™ Deduplication Guide

Last Published: 2020-09-14

Product(s): NetBackup (8.3.0.1)

Microsoft SQL Server stream handler

You can apply the Microsoft SQL Server stream handler to all of the Microsoft SQL Server version and Azure SQL Server. You can use the MS-SQL policy or the Standard policy to enable this feature.

You can enable and disable the Microsoft SQL Server stream handler per policy or all policies at once using the cacontrol command line utility.

The Marker Entry file is used to override the default behavior by using thecacontrol command utility with the --sth flag at a client and or policy level only.

The Marker Entry configuration file is stored at the following location:

/MDSP_SERVER/databases/spa/marker.cfg

Update a Marker Entry policy by using the following cacontrol options:

You can create and or update a Marker Entry policy.

cacontrol --sth update <STHTYPE> <CLIENT> <POLICY> [SPAUSER] <enabled | disabled>

You can query the setting for the stream handler per policy.
```
cacontrol --sth get <STHTYPE> <CLIENT> <POLICY> [SPAUSER]
```

You can delete the settings to use the default behavior.

cacontrol --sth delete <STHTYPE> <CLIENT> <POLICY> [SPAUSER]

When you enable the Microsoft SQL Server stream handler, the Job Details tab in the Administration Console displays the following:

MS-SQL stream handler enabled