Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
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).



Scroll pdf ignore
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
 | 
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
 | 
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
 | 
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
|
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
 |
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse