Skip to main content
Sign Out

Welcome to Dell

My Account
  • Place orders quickly and easily
  • View orders and track your shipping status
  • Enjoy members-only rewards and discounts
  • Create and access a list of your products
  • Manage your Dell EMC sites, products, and product-level contacts using Company Administration.
Sign In Create an Account Dell Financial Services Premier Sign In Partner Program Sign In
Contact Us

Your Dell.com Carts

PowerProtect Data Manager Appliance 5.16.0.0 Microsoft SQL Server User Guide

PDF

Enable the use of pre-scripts and post-scripts with backups

PowerProtect Data Manager Appliance supports the running of user-created scripts before and after a centralized backup on an application agent host. You can optionally create a pre-script that runs before a backup or a post-script that runs after a backup. These pre-scripts and post-scripts can perform various functions that extend the capabilities of the backup process.

PowerProtect Data Manager Appliance supports the use of pre-scripts and post-scripts with backups of the assets or databases of the following application agents:

  • File System agent on AIX, Linux, or Windows
  • Microsoft Exchange Server application agent on Windows
  • Microsoft SQL Server application agent on Windows
  • Oracle RMAN agent on AIX or Linux
  • SAP HANA application agent on Linux

E-Lab Navigator provides details on the latest platform support for the application agents.

For example, you can create a pre-script that stops a database, stops services, deletes unwanted files, or changes permissions before a backup begins to run. You can also create a post-script that starts a database, starts services, or applies transaction logs after a backup completes. You can specify that a pre-script runs before a specific backup or a post-script runs after a specific backup, or that both scripts run before and after the same backup.

Each script file name must be unique. The name must end with .sh on Linux or UNIX and .bat on Windows. On Windows, a double extension is not supported, as in the script name myscript.bat.exe. It is recommended that you include the type of script within the script name. For example:

  • Pre-script name: ppdm_pre_backup.sh or ppdm_pre_backup.bat
  • Post-script name: ppdm_post_backup.sh or ppdm_post_backup.bat

For example, the Oracle RMAN agent is supported only on AIX or Linux, so you must use an Oracle script name that ends with .sh.

NOTE:

The script content must be in text format with a maximum size of 20 KB. The maximum number of scripts that a PowerProtect Data Manager Appliance server supports is 10,000. A maximum of one pre-script and one post-script can run with a backup on Linux, UNIX, or Windows.

The pre-scripts and post-scripts must be created, validated, and maintained by the user. PowerProtect Data Manager Appliance is not involved in these operations on scripts.

CAUTION:The functions that the scripts can perform are not restricted. However, ensure that the scripts do not include dangerous commands, such as rm -rf on Linux or UNIX, which can produce unwanted results, harm the environment, or corrupt the host. Do not include any passwords in plain text within the scripts. PowerProtect Data Manager Appliance users can view such passwords, which can pose a security risk. It is recommended that you thoroughly test all scripts before using them in a production environment.

By default, the use of scripts with a backup is disabled. After you create a pre-script or post-script, you must enable its use with backups, as described in the following topics.

The pre-scripts and post-scripts that you use with backups must be uploaded and stored on the PowerProtect Data Manager Appliance server:

  • You can upload any required scripts to the PowerProtect Data Manager Appliance server, and download scripts from the server.
  • You can determine which scripts have been stored on the server.
  • Only an administrator can add, edit, and delete the scripts that are stored on the server. All users can view the scripts.
  • You must enable the use of pre-scripts and post-scripts with backups on the host either during the application agent installation or later.

PowerProtect Data Manager Appliance does not cancel running scripts. When you request the cancellation of a protection job, PowerProtect Data Manager Appliance cancels the protection job of the assets but does not cancel any running pre-script. When a protection job is canceled before completion, a post-script does not run.

NOTE:Depending on the pre-script content, cancellation of a protection job that involves a pre-script might result in an inconsistent state on the application agent host. The pre-script is not canceled when the protection job is canceled.

Review the following topics to prepare for the use of pre-scripts and post-scripts with centralized backups. Review the details about the content requirements and examples of pre-script and post-script content.

Rate this content

Accurate
Useful
Easy to understand
Was this article helpful?
0/3000 characters
  Please provide ratings (1-5 stars).
  Please provide ratings (1-5 stars).
  Please provide ratings (1-5 stars).
  Please select whether the article was helpful or not.
  Comments cannot contain these special characters: <>()\