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 install SQL Server extended stored procedures (XSP) for SQLsafe.

 

To perform the installation use the following command:
  •   SQLsafeCmd InstallXsp [options]

Common Options

The following options help you perform the installation:

Options
Descriptions
-InstanceName

SQL server instance name.

To specifiy all instances, use an asterisk (*) for the instance name.

Note: it is not required if the instance is the set as a default instance on the target server.

-Server

The remote server that hosts the SQL Server instance(s) where the extended stored
procedures should be installed (or uninstalled).

Security Options

Secure your installation with the following options:

Options
Description
-NoPrompt  Never prompt for credentials even if necessary.
-SecurityModel <model>

The security model used to log into SQL Server.

<model> - Integrated or SQL {Integrated, SQL}.

Note: Integrated (Windows authentication) is the default.

-SqlUsername <username><username> - the SQL Server username. (SQL SecurityModel).
-SqlPassword <pwd><pwd> - the SQL Server password. (SQL SecurityModel).
-EncryptedSqlPassword <pwd><pwd> - the encrypted SQL Server password generated by EncryptSqlPassword action. (SQL
SecurityModelSQLSecurityModel).
-WindowsUsername

The Windows user that will be used during the installation process.

-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 installation:

Options
Description
-ArgsFile <filename>

The path to a file containing command-line arguments.

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

-Remove

Remove all SQLsafe extended stored procedures from the specified instance(s).

For detailed descriptions and available options, see the CLI Help (SQLsafecmd help installxsp).

SQL Safe is a high-performance backup and recovery solution for your SQL Servers. Learn more > >