SQLTestDB
database will be backed up to disk at the default backup location.SQLTestDB
, point to Tasks, and then click Back Up....SQLTestDB
database will be backed up to disk at a location of your choice.SQLTestDB
, point to Tasks, and then click Back Up....SQLTestDB
database will be backed up with encryption to the default backup location.master
, and click New Query to open a query window with a connection to your SQLTestDB
database.master
database.SQLTestDB
, point to Tasks, and then click Back Up....MyCertificate
.SQLTestDB
to the Microsoft Azure Blob storage service. This example assumes that you already have a storage account with a blob container. This example creates a shared access signature for you; this example fails of the container has an existing shared access signature. If you do not have an Azure blob container in a storage account, create one before continuing. For more information, see Create a general purpose storage account and Create a container.SQLTestDB
, point to Tasks, and then click Back Up....Option | Description |
---|---|
database | Is the database that is to be backed up. |
backup_device [ ,...n ] | Specifies a list of from 1 to 64 backup devices to use for the backup operation. You can specify a physical backup device, or you can specify a corresponding logical backup device, if already defined. To specify a physical backup device, use the DISK or TAPE option: { DISK | TAPE } =physical_backup_device_name For more information, see Backup Devices (SQL Server). |
WITH with_options [ ,...o ] | Optionally, specifies one or more additional options, o. For information about some of the basic with options, see step 2. |
NOINIT
option. For information about appending to existing backup sets, see Media Sets, Media Families, and Backup Sets (SQL Server).SQLTestDB
database to disk, by using FORMAT
to create a new media set.SQLTestDB
database to tape, appending the backup to the previous backups.SQLTestDB
database to the default backup location of the server instance ComputerInstance
. Optionally, this example specifies -BackupAction Database. For the full syntax and additional examples, see Backup-SqlDatabase.Get-Module -Name SqlServer
. To install this module, run Install-Module -Name SqlServer
in an administrator session of PowerShell. For more information, see SQL Server PowerShell Provider.SQLTestDB
on the MyServer
instance to the Microsoft Azure Blob Storage service. A stored access policy has been created with read, write, and list rights. The SQL Server credential, https://mystorageaccount.blob.core.windows.net/myfirstcontainer
, was created using a Shared Access Signature that is associated with the Stored Access Policy. The PowerShell command uses the BackupFile parameter to specify the location (URL) and the backup file name.