.TH "GCLOUD_ALPHA_SQL_EXPORT_BAK" 1



.SH "NAME"
.HP
gcloud alpha sql export bak \- export data from a Cloud SQL instance to a BAK file



.SH "SYNOPSIS"
.HP
\f5gcloud alpha sql export bak\fR \fIINSTANCE\fR \fIURI\fR \fB\-\-database\fR=\fIDATABASE\fR,[\fIDATABASE\fR,...], \fB\-d\fR \fIDATABASE\fR,[\fIDATABASE\fR,...] [\fB\-\-async\fR] [\fB\-\-bak\-type\fR=\fIBAK_TYPE\fR;\ default="FULL"] [\fB\-\-differential\-base\fR] [\fB\-\-export\-log\-end\-time\fR=\fIEXPORT_LOG_END_TIME\fR] [\fB\-\-export\-log\-start\-time\fR=\fIEXPORT_LOG_START_TIME\fR] [\fB\-\-stripe_count\fR=\fISTRIPE_COUNT\fR] [\fB\-\-[no\-]striped\fR] [\fIGCLOUD_WIDE_FLAG\ ...\fR]



.SH "DESCRIPTION"

\fB(ALPHA)\fR Export data from a Cloud SQL instance to a Google Cloud Storage
bucket as a BAK backup file. This is only supported for SQL Server.



.SH "EXAMPLES"

To export data from the database \f5my\-database\fR in the Cloud SQL instance
\f5my\-instance\fR to a BAK file \f5my\-bucket/my\-export.bak\fR, run:

.RS 2m
$ gcloud alpha sql export bak my\-instance \e
    gs://my\-bucket/my\-export.bak \-\-database=my\-database
.RE



.SH "POSITIONAL ARGUMENTS"

.RS 2m
.TP 2m
\fIINSTANCE\fR

Cloud SQL instance ID.

.TP 2m
\fIURI\fR

The path to the file in Google Cloud Storage where the export will be stored.
The URI is in the form gs://bucketName/fileName. If the file already exists, the
operation fails.


.RE
.sp

.SH "REQUIRED FLAGS"

.RS 2m
.TP 2m
\fB\-\-database\fR=\fIDATABASE\fR,[\fIDATABASE\fR,...], \fB\-d\fR \fIDATABASE\fR,[\fIDATABASE\fR,...]

Database from which the export is made. Information on requirements can be found
here:
https://cloud.google.com/sql/docs/sqlserver/admin\-api/v1beta4/instances/export#exportContext.databases


.RE
.sp

.SH "OPTIONAL FLAGS"

.RS 2m
.TP 2m
\fB\-\-async\fR

Return immediately, without waiting for the operation in progress to complete.

.TP 2m
\fB\-\-bak\-type\fR=\fIBAK_TYPE\fR; default="FULL"

Type of bak file that will be exported, FULL or DIFF. SQL Server only.
\fIBAK_TYPE\fR must be one of: \fBFULL\fR, \fBDIFF\fR, \fBTLOG\fR.

.TP 2m
\fB\-\-differential\-base\fR

Whether the bak file export can be used as differential base for future
differential backup. SQL Server only

.TP 2m
\fB\-\-export\-log\-end\-time\fR=\fIEXPORT_LOG_END_TIME\fR

Optional flag. The end time of the transaction log files that are included in
the export file. Use this flag to export transaction logs for Cloud SQL for SQL
Server only. Format: YYYY\-MM\-DDTHH:MM:SSZ, UTC timezone only.

.TP 2m
\fB\-\-export\-log\-start\-time\fR=\fIEXPORT_LOG_START_TIME\fR

Optional flag. The start time of the transaction log files that are included in
the export file. Use this flag to export transaction logs for Cloud SQL for SQL
Server only. Format: YYYY\-MM\-DDTHH:MM:SSZ, UTC timezone only.

.TP 2m
\fB\-\-stripe_count\fR=\fISTRIPE_COUNT\fR

Specifies the number of stripes to use for SQL Server exports.

.TP 2m
\fB\-\-[no\-]striped\fR

Whether SQL Server export should be striped. Use \fB\-\-striped\fR to enable and
\fB\-\-no\-striped\fR to disable.


.RE
.sp

.SH "GCLOUD WIDE FLAGS"

These flags are available to all commands: \-\-access\-token\-file, \-\-account,
\-\-billing\-project, \-\-configuration, \-\-flags\-file, \-\-flatten,
\-\-format, \-\-help, \-\-impersonate\-service\-account, \-\-log\-http,
\-\-project, \-\-quiet, \-\-trace\-token, \-\-user\-output\-enabled,
\-\-verbosity.

Run \fB$ gcloud help\fR for details.



.SH "NOTES"

This command is currently in alpha and might change without notice. If this
command fails with API permission errors despite specifying the correct project,
you might be trying to access an API with an invitation\-only early access
allowlist. These variants are also available:

.RS 2m
$ gcloud sql export bak
.RE

.RS 2m
$ gcloud beta sql export bak
.RE