Date: Fri, 29 Mar 2024 02:04:44 +0000 (GMT) Message-ID: <196927058.543.1711677884091@ip-172-31-38-4.eu-west-1.compute.internal> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_542_1129504816.1711677884085" ------=_Part_542_1129504816.1711677884085 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
SQBHostedStorageClient.exe is only available with SQL Backup Pro 7= .3 and later.
SQL Backup Hosted Storage Client (SQBHostedStorageClient.exe) is a comma= nd-line utility that allows you to upload SQL Backup backups to a SQL Backu= p Pro Hosted Storage account. This is useful if:
You can also use the utility to link a SQL Server instance to a Hosted S= torage account.
Command | Syntax | Description |
---|---|---|
upload |
SQBHostedStorageClient.exe upload [-i=
|=E2=80=93instance=3D<instance name>] [-p|=E2=80=93password=3D&l=
t;backup password>] <file name> |
Uploads the specified file to the Hosted Stor= age account linked to the specified SQL Server instance. Enter the fu= ll path to the SQL Backup backup file, for example: C:\Program Files\Mi= crosoft 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 enc= rypted backup file are then uploaded to hosted storage over a secure connec= tion. The password is not sent. |
authorize |
SQBHostedStorageClient.exe authorize =
[-i|=E2=80=93instance=3D<instance name> [-f|--force=
] <email address> <password> |
Links the specified SQL Server instance to the H=
osted 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 e= mail address and password for the account. To create an account, go to = ;http://sqlbackup.red-gate.com. Specify the SQL Server i= nstance that you want to link to the Hosted Storage account. If not specifi= ed, the default instance is used. If the SQL Server instance is alrea=
dy linked to another account, use Note: You can = also link a SQL Server instance to an account from the Hosted Storage Setti= ngs in the SQL Backup GUI. For more information, see Hosted storage settings. |
version |
SQBHostedStorageClient.exe version <=
/td>
| Displays version information for SQBHostedSto= rageClient.exe. If you are working with Red Gate Support, you m= ay be asked to provide this information. |
help |
SQBHostedStorageClient.exe help <comman=
d> |
Displays help information for each command. |
Open a Command Prompt window and find SQBHostedStorageClient.exe.&nb=
sp;SQBHostedStorageClient.exe is located in the same folder as the server c=
omponents (by default %ProgramFiles%\Red Gate\SQL Backup 8\<instance=
name> on 32-bit machines or %ProgramFiles (x86)%\Red Gate\SQL =
Backup 8\<instance name> on 64-bit machines).
Either, navigate to the folder in Windows Explorer, hold SHIFT, right-clic=
k and select Open command window here, or open a Command P=
rompt window anywhere and change directory to the relevant folder. For exam=
ple:
cd C:\P= rogramFiles\Red Gate\SQL Backup 8\(Local)
The following command uploads the backup C:\Backups\AdventureWorks_F= ull.sqb to the Hosted Storage account linked to the Production SQL Server:
SQBHost= edStorageClient.exe upload -i=3DProduction C:\Backups\AdventureWorks_Full.s= qb
The following command uploads the encrypted backup C:\Backups\Northw= ind_Full_20130102.sqb to the Hosted Storage account linked to the defa= ult SQL Server instance (local):
SQBHost= edStorageClient.exe upload -p=3DPassword1 C:\Backups\Northwind_Full_2013010= 2.sqb
The following command links the default SQL Server instance (local)<= /em> to a Hosted Storage account:
SQBHost= edStorageClient.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 li= nked to:
SQBHost= edStorageClient.exe authorize -i=3DProduction -f dba@example.com Password1<= /pre>