SQBHostedStorageClient.exe is only available with SQL Backup Pro 7.3 and later. |
SQL Backup Hosted Storage Client (SQBHostedStorageClient.exe) is a command-line utility that allows you to upload SQL Backup backups to a SQL Backup Pro Hosted Storage account. This is useful if:
You can also use the utility to link a SQL Server instance to a Hosted Storage account.
| Command | Syntax | Description |
|---|---|---|
upload | SQBHostedStorageClient.exe upload [-i|–instance=<instance name>] [-p|–password=<backup password>] <file name> | Uploads the specified file to the Hosted Storage account linked to the specified SQL Server instance. Enter the full path to the SQL Backup backup file, for example: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\MyBackup.sqb Specify the SQL Server instance that is linked to the Hosted Storage account you want to upload to. If not specified, the default instance is used. If the backup is encrypted, specify the backup password. SQL Backup Hosted Storage Client uses the password to read the backup metadata. The metadata and encrypted backup file are then uploaded to hosted storage over a secure connection. The password is not sent. |
authorize | SQBHostedStorageClient.exe authorize [-i|–instance=<instance name> [-f|--force] <email address> <password> | Links the specified SQL Server instance to the Hosted Storage account. This is only necessary if the instance is not linked to an account or if you want to link to a different account. Enter the email address and password for the account. To create an account, go to http://sqlbackup.red-gate.com. Specify the SQL Server instance that you want to link to the Hosted Storage account. If not specified, the default instance is used. If the SQL Server instance is already linked to another account, use Note: You can also link a SQL Server instance to an account from the Hosted Storage Settings in the SQL Backup GUI. For more information, see Hosted storage settings. |
version | SQBHostedStorageClient.exe version | Displays version information for SQBHostedStorageClient.exe. If you are working with Red Gate Support, you may be asked to provide this information. |
help | SQBHostedStorageClient.exe help <command> | Displays help information for each command. |
Open a Command Prompt window and find SQBHostedStorageClient.exe. SQBHostedStorageClient.exe is located in the same folder as the server components (by default %ProgramFiles%\Red Gate\SQL Backup 7\<instance name> on 32-bit machines or %ProgramFiles (x86)%\Red Gate\SQL Backup 7\<instance name> on 64-bit machines).
Either, navigate to the folder in Windows Explorer, hold SHIFT, right-click and select Open command window here, or open a Command Prompt window anywhere and change directory to the relevant folder. For example:
cd C:\ProgramFiles\Red Gate\SQL Backup 7\(Local) |
The following command uploads the backup C:\Backups\AdventureWorks_Full.sqb to the Hosted Storage account linked to the Production SQL Server:
SQBHostedStorageClient.exe upload -i=Production C:\Backups\AdventureWorks_Full.sqb |
The following command uploads the encrypted backup C:\Backups\Northwind_Full_20130102.sqb to the Hosted Storage account linked to the default SQL Server instance (local):
SQBHostedStorageClient.exe upload -p=Password1 C:\Backups\Northwind_Full_20130102.sqb |
The following command links the default SQL Server instance (local) to a Hosted Storage account:
SQBHostedStorageClient.exe authorize dba@example.com Password1 |
The following command links the Production SQL Server instance to a new Hosted Storage account, replacing the account it was previously linked to:
SQBHostedStorageClient.exe authorize -i=Production -f dba@example.com Password1 |