Post Script in MS SQL backup

[Piotrek_B]

Hi 

I'm looking for some kind of POST script which will run after backup of MS SQL database policy. This post script should be on my NetBackup Master Server. 

I tried to use 'bpend' but it's not suppose to works with SQL policy :(

Regards

[Stephane_COLIN · Accepted solution]

I confirm, it's not possible to use these client scripts : "bpstart_notify", "bpend_notify", ....

You can used this alternative:

   - Create a policy MS-Windows (for example : PL-SQL-START)
      * Client : Your SQL Server
      * Schedule : Your backup plan
      * File list : Your script (for example)

   - Create a policy SQL-Server (PL-SQL)
      * Schedule : Application backup schedule
      * Client : Your SQL Server
      * Script : Your SQL Script (it's not important)

   - Create on your SQL client a bpstart_notify.PL-SQL-START. (associated to PL-SQL-START)
      * Integrate your operations (before backup)
      * At the end of script :
            dbbackex.exe -f "yout SQL backup script .bch" -np
            echo %errorlevel% > %6
            exit /b

Warning, this methode requires positionning a very large bpstart_notify_timeout (host properties --> Master Server)