SQL Safe provides you with CLI commands to help you manually delete backup archives older than the specified date.


To perform delete operations use the following command:

  • SQLsafeCmd Delete <filename> [options]

Where the required [options] are:

Options
Descriptions
<filename>

The path and filename to be deleted.

An asterisk (*) can be used in the filename to delete multiple files at once.

-Age <n><time_period>

Delete/Expire archives that are older than the specified amount of time.

 <n> - amount of time.

<time_period> - {minutes, hours, days, weeks, months}.

Note: There must be NO SPACE between <n> and <time_period>.

E.g., -age 2hours.

Security Options

Secure your delete operations with the following options:

Options
Description
-WindowsUsername <domain\user><domain\user> - the Windows user that will be used to read/write the backup archive.
-WindowsPassword <pwd><pwd> - the password for the Windows user.
-EncryptedWindowsPassword <pwd><pwd> - the encrypted password for the Windows user generated by EncryptWindowsPassword action. 

Advanced Options

The following advanced options help you perform your delete operations:

Options
Description
-IncludeSubdirectories

If set, includes subdirectories when finding files to delete.

-ArgsFile <filename>

The path to a file containing command-line arguments.

<filename> - specifies the file that contains the command line arguments.

-No Prompt

Do not prompt for confirmation before deleting files.

For detailed descriptions and available options, see the CLI Help (SQLsafeCmd help Delete).


  • No labels