備份裝置 (SQL Server)Backup Devices (SQL Server)

適用於: 是SQL Server 否Azure SQL Database 否Azure Synapse Analytics (SQL DW) 否平行處理資料倉儲 APPLIES TO: yesSQL Server noAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

SQL ServerSQL Server 資料庫上進行備份作業期間,備份的資料 (「備份」 ) 會寫入至實體備份裝置。During a backup operation on a SQL ServerSQL Server database, the backed up data (the backup) is written to a physical backup device. 當媒體集的第一個備份寫入此實體備份裝置時,此裝置就會初始化。This physical backup device is initialized when the first backup in a media set is written to it. 單一媒體集是由一組一個或多個備份裝置上的備份所組成。Backups on a set of one or more backup devices compose a single media set.

詞彙和定義Terms and definitions

備份磁碟backup disk
包含一個或多個備份檔案的硬碟或其他磁碟儲存媒體。A hard disk or other disk storage media that contains one or more backup files. 備份檔案是一般作業系統檔案。A backup file is a regular operating system file.

媒體集media set
按順序排列的備份媒體、磁帶或磁碟檔案集合,而且它會使用備份裝置的固定類型和編號。An ordered collection of backup media, tapes or disk files, that uses a fixed type and number of backup devices. 如需媒體集的詳細資訊,請參閱 媒體集、媒體家族與備份組 (SQL Server)For more information about media sets, see Media Sets, Media Families, and Backup Sets (SQL Server).

實體備份裝置physical backup device
磁帶機或作業系統所提供的磁碟檔案。Either a tape drive or a disk file that is provided by the operating system. 備份可以寫入 1 到 64 部備份裝置。A backup can be written to from 1 to 64 backup devices. 如果備份需要多部備份裝置,這些裝置都必須對應至單一裝置類型 (磁碟或磁帶)。If a backup requires multiple backup devices, the devices all must correspond to a single type of device (disk or tape).

除了磁碟或磁帶之外,SQL Server 備份也可以寫入 Azure Blob 儲存體服務。SQL Server Backups can also be written to Azure Blob storage service in addition to disk or tape.

使用磁碟備份裝置Using disk backup devices

如果備份作業將備份附加至媒體集時,磁碟檔案填滿,備份作業就會失敗。If a disk file fills while a backup operation is appending a backup to the media set, the backup operation fails. 由於備份檔案的大小上限是由磁碟裝置上的可用磁碟空間決定,所以備份磁碟裝置的適當大小要根據您的備份大小而定。The maximum size of a backup file is determined by the free disk space available on the disk device; therefore, the appropriate size for a backup disk device depends on the size of your backups.

磁碟備份裝置可以是簡單的磁碟裝置,例如 ATA 磁碟機。A disk backup device could be a simple disk device, such as an ATA drive. 或者,您也可以使用可熱抽換的 (Hot-swappable) 磁碟機,以便您將磁碟機上寫滿的磁碟直接了當地更換成空的磁碟。Alternatively, you could use a hot-swappable disk drive that would let you transparently replace a full disk on the drive with an empty disk. 備份磁碟可以是伺服器上的本機磁碟,也可以是屬於共用網路資源的遠端磁碟。A backup disk can be a local disk on the server or a remote disk that is a shared network resource. 如需有關如何使用遠端磁碟的詳細資訊,請參閱本主題後面的< 備份至網路共用上的檔案>。For information about how to use a remote disk, see Backing Up to a File on a Network Share, later in this topic.

SQL ServerSQL Server 管理工具在處理磁碟備份裝置時相當有彈性,因為它們會自動在磁碟檔案上產生具有時間戳記的名稱。management tools are very flexible at handling disk backup devices because they automatically generate a time-stamped name on the disk file.

重要!IMPORTANT! 我們建議備份磁碟應該與資料庫資料和記錄磁碟使用不同的磁碟。We recommend that a backup disk be a different disk than the database data and log disks. 為了確保您可以在資料或記錄磁碟故障時存取備份,這樣做有其必要。This is necessary to make sure that you can access the backups if the data or log disk fails.

如果資料庫檔案和備份檔案位於相同的裝置上,而且該裝置發生錯誤,將無法使用資料庫和備份。If database files and backup files are on the same device and the device fails, the database and backups will be unavailable. 此外,將資料庫和備份檔案放在不同裝置上會將資料庫的生產使用和寫入備份的 I/O 效能最佳化。Also, putting the database and backup files on the separate devices optimizes the I/O performance for both the production use of the database and the writing of backups.

使用實體名稱來指定備份檔案 (Transact-SQL)Specify a backup file using its physical name (Transact-SQL)

使用實體裝置名稱來指定備份檔案的基本 BACKUP 語法為:The basic BACKUP syntax for specifying a backup file by using its physical device name is:

BACKUP DATABASE database_nameBACKUP DATABASE database_name

TO DISK = { ' physical_backup_device_name ' | @ physical_backup_device_name_var }TO DISK = { 'physical_backup_device_name' | @physical_backup_device_name_var }

例如:For example:

BACKUP DATABASE AdventureWorks2012   
   TO DISK = 'Z:\SQLServerBackups\AdventureWorks2012.bak';  
GO  

若要在 RESTORE 陳述式中指定實體磁碟裝置,基本語法為:To specify a physical disk device in a RESTORE statement, the basic syntax is:

RESTORE { DATABASE | LOG } database_nameRESTORE { DATABASE | LOG } database_name

FROM DISK = { ' physical_backup_device_name ' | @ physical_backup_device_name_var }FROM DISK = { 'physical_backup_device_name' | @physical_backup_device_name_var }

例如,For example,

RESTORE DATABASE AdventureWorks2012   
   FROM DISK = 'Z:\SQLServerBackups\AdventureWorks2012.bak';   

指定磁碟備份檔案路徑Specify the disk backup file path

指定備份檔案時,您應該輸入完整路徑及檔案名稱。When you are specifying a backup file, you should enter its full path and file name. 當您要備份至檔案時,如果僅指定檔案名稱或相對路徑,便會將備份檔案放在預設的備份目錄中。If you specify only the file name or a relative path when you are backing up to a file, the backup file is put in the default backup directory. 預設的備份目錄為 C:\Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\Backup,其中 n 是伺服器執行個體的編號。The default backup directory is C:\Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\Backup, where n is the number of the server instance. 因此,針對預設伺服器執行個體,預設備份目錄是:C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Backup。Therefore, for the default server instance, the default backup directory is: C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Backup.

若要避免模稜兩可的情形 (特別是在指令碼中),建議您在每個 DISK 子句中明確指定備份目錄的路徑。To avoid ambiguity, especially in scripts, we recommend that you explicitly specify the path of the backup directory in every DISK clause. 不過,當您使用「查詢編輯器」時,這就不是那麼重要。However, this is less important when you are using Query Editor. 在這種情況下,如果您確定備份檔案是在預設的備份目錄中,即可省略 DISK 子句中的路徑。In that case, if you are sure that the backup file resides in the default backup directory, you can omit the path from a DISK clause. 例如,下列 BACKUP 陳述式會將 AdventureWorks2012AdventureWorks2012 資料庫備份到預設備份目錄。For example, the following BACKUP statement backs up the AdventureWorks2012AdventureWorks2012 database to the default backup directory.

BACKUP DATABASE AdventureWorks2012   
   TO DISK = 'AdventureWorks2012.bak';  
GO  

注意: 預設位置會儲存在 HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.n\MSSQLServer 下的 BackupDirectory登錄機碼。NOTE: The default location is stored in the BackupDirectory registry key under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.n\MSSQLServer.

備份至網路共用檔案Back up to a network share file

為了讓 SQL ServerSQL Server 存取遠端磁碟檔案, SQL ServerSQL Server 服務帳戶必須具有網路共用的存取權。For SQL ServerSQL Server to access a remote disk file, the SQL ServerSQL Server service account must have access to the network share. 這包括具有讓備份作業寫入網路共用以及讓還原作業從中讀取所需的權限。This includes having the permissions needed for backup operations to write to the network share and for restore operations to read from it. 網路磁碟機和權限的可用性會根據 SQL ServerSQL Server 服務執行的內容而定:The availability of network drives and permissions depends on the context is which SQL ServerSQL Server service is running:

  • SQL ServerSQL Server 在網域使用者帳戶下執行時,若要備份至網路磁碟機,共用磁碟機就必須對應成 SQL ServerSQL Server 正在執行之工作階段中的網路磁碟機。To back up to a network drive when SQL ServerSQL Server is running in a domain user account, the shared drive must be mapped as a network drive in the session where SQL ServerSQL Server is running. 如果是從命令列啟動 Sqlservr.exe, SQL ServerSQL Server 便看得到您登入工作階段中已對應的所有網路磁碟機。If you start Sqlservr.exe from command line, SQL ServerSQL Server sees any network drives you have mapped in your login session.

  • 不過,如果 Sqlservr.exe 是以服務方式執行,則 SQL ServerSQL Server 會在另一個與登入工作階段無關的工作階段中執行。When you run Sqlservr.exe as a service, SQL ServerSQL Server runs in a separate session that has no relation to your login session. 服務執行的工作階段可擁有自己的對應磁碟機 (只是它通常沒有)。The session in which a service runs can have its own mapped drives, although it usually does not.

  • 您可以使用電腦帳戶代替網域使用者來與網路服務帳戶連接。You can connect with the network service account by using the computer account instead of a domain user. 若要允許從特定電腦備份至共用磁碟機,請將存取權授與電腦帳戶。To enable backups from specific computers to a shared drive, grant access to the computer accounts. 只要正在寫入備份的 Sqlservr.exe 處理序具有存取權,傳送 BACKUP 命令的使用者是否具有存取權便無關了。As long as the Sqlservr.exe process that is writing the backup has access, it is irrelevant whether the user sending the BACKUP command has access.

    重要!IMPORTANT! 透過網路備份資料可能會受到網路問題的影響。因此,我們建議您在使用遠端磁碟時,於備份作業完成後進行驗證。Backing up data over a network can be subject to network errors; therefore, we recommend that when you are using a remote disk you verify the backup operation after it finishes. 如需詳細資訊,請參閱 RESTORE VERIFYONLY (Transact-SQL)For more information, see RESTORE VERIFYONLY (Transact-SQL).

指定通用命名慣例 (UNC) 名稱Specify a Universal Naming Convention (UNC) name

若要在備份或還原命令中指定網路共用,請使用備份裝置檔案的完整通用命名慣例 (UNC) 名稱。To specify a network share in a backup or restore command, use the fully qualified universal naming convention (UNC) name of the file for the backup device. UNC 名稱的格式為 \\ <系統名稱> \ <共用名稱> \ <路徑> \ <檔案名稱> 。A UNC name has the form \\Systemname\ShareName\Path\FileName.

例如:For example:

BACKUP DATABASE AdventureWorks2012   
   TO DISK = '\\BackupSystem\BackupDisk1\AW_backups\AdventureWorksData.Bak';  
GO  

使用磁帶裝置Using tape devices

注意: 未來的 SQL ServerSQL Server版本中將會移除磁帶備份裝置的支援。NOTE: Support for tape backup devices will be removed in a future version of SQL ServerSQL Server. 請避免在新的開發工作中使用這項功能,並規劃修改目前使用這項功能的應用程式。Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

磁帶機必須是 SQL ServerSQL Server Windows 作業系統所支援的,才能將 MicrosoftMicrosoft 資料備份到磁帶中。Backing up SQL ServerSQL Server data to tape requires that the tape drive or drives be supported by the MicrosoftMicrosoft Windows operating system. 此外,對指定的磁帶機而言,我們建議您僅使用磁帶機製造商所建議的磁帶。Additionally, for the given tape drive, we recommend that you use only tapes recommended by the drive manufacturer. 如需有關如何安裝磁帶機的詳細資訊,請參閱 Windows 作業系統的文件。For more information about how to install a tape drive, see the documentation for the Windows operating system.

使用磁帶機時,備份作業可能會填滿一捲磁帶,然後繼續寫入另一捲磁帶。When a tape drive is used, a backup operation may fill one tape and continue onto another tape. 每個磁帶都含有媒體標頭。Each tape contains a media header. 第一個使用的媒體稱為 「初始磁帶」The first media used is called the initial tape. 後續的磁帶都稱為 接續磁帶 ,每捲磁帶都有一個媒體序號,後面的磁帶編號比前面的高。Each successive tape is known as a continuation tape and has a media sequence number that is one higher than the previous tape. 例如,與四個磁帶裝置相關聯的媒體集,內含至少四捲初始磁帶;而如果一捲磁帶裝不下整個資料庫,則還會有四捲接續磁帶。For example, a media set associated with four tape devices contains at least four initial tapes (and, if the database does not fit, four series of continuation tapes). 附加備份組的時候,您必須掛載整組媒體中的最後一捲磁帶。When appending a backup set, you must mount the last tape in the series. 若未掛載最後一捲磁帶, Database EngineDatabase Engine 往前掃描到掛載磁帶的結尾時,便會要求您更換磁帶。If the last tape is not mounted, the Database EngineDatabase Engine scans forward to the end of the mounted tape and then requires that you change the tape. 此時,請掛載最後一捲磁帶。At that point, mount the last tape.

使用磁帶備份裝置就像使用磁碟裝置一樣,但有以下例外情況:Tape backup devices are used like disk devices, with the following exceptions:

  • 磁帶裝置必須在實體上連接至執行 SQL ServerSQL Server執行個體的電腦。The tape device must be connected physically to the computer that is running an instance of SQL ServerSQL Server. 不支援備份至遠端磁帶裝置。Backing up to remote tape devices is not supported.

  • 如果在備份作業進行時磁帶備份裝置填滿,但還必須寫入更多資料的話, SQL ServerSQL Server 會提示換新磁帶,並於載入新磁帶後繼續進行備份作業。If a tape backup device is filled during the backup operation, but more data still must be written, SQL ServerSQL Server prompts for a new tape and continues the backup operation after a new tape is loaded.

使用實體名稱來指定備份磁帶 (Transact-SQL)Specify a backup tape using its physical name (Transact-SQL)

使用磁帶機之實體裝置名稱來指定備份磁帶的基本 BACKUP 語法為:The basic BACKUP syntax for specifying a backup tape using the physical device name of the tape drive is:

BACKUP { DATABASE | LOG } database_nameBACKUP { DATABASE | LOG } database_name

TO TAPE = { ' physical_backup_device_name ' | @ physical_backup_device_name_var }TO TAPE = { 'physical_backup_device_name' | @physical_backup_device_name_var }

例如:For example:

BACKUP LOG AdventureWorks2012   
   TO TAPE = '\\.\tape0';  
GO  

若要在 RESTORE 陳述式中指定實體磁帶裝置,基本語法為:To specify a physical tape device in a RESTORE statement, the basic syntax is:

RESTORE { DATABASE | LOG } database_nameRESTORE { DATABASE | LOG } database_name

FROM TAPE = { ' physical_backup_device_name ' | @ physical_backup_device_name_var }FROM TAPE = { 'physical_backup_device_name' | @physical_backup_device_name_var }

磁帶專用的 BACKUP 和 RESTORE 選項 (Transact-SQL)Tape-Specific BACKUP and RESTORE options (Transact-SQL)

為了方便磁帶管理作業,BACKUP 陳述式提供了下列磁帶專用的選項:To facilitate tape management, the BACKUP statement provides the following tape-specific options:

  • { NOUNLOAD | UNLOAD }{ NOUNLOAD | UNLOAD }

    您可以控制在備份或還原作業之後,備份磁帶是否會自動從磁帶機卸載。You can control whether a backup tape is unloaded automatically from the tape drive after a backup or restore operation. UNLOAD/NOUNLOAD 是工作階段設定,在工作階段的存留期間會一直保持不變,直到指定其他設定來進行重設為止。UNLOAD/NOUNLOAD is a session setting that persists for the life of the session or until it is reset by specifying the alternative.

  • { REWIND | NOREWIND }{ REWIND | NOREWIND }

    您可以控制在備份或還原作業之後, SQL ServerSQL Server 會將磁帶保持在開啟狀態,還是會在磁帶填滿之後,釋出並倒轉磁帶。You can control whether SQL ServerSQL Server keeps the tape remains open after the backup or restore operation or releases and rewinds the tape after it fills. 預設行為是倒轉磁帶 (REWIND)。The default behavior is to rewind the tape (REWIND).

注意: 如需 BACKUP 語法和引數的詳細資訊,請參閱 BACKUP (Transact-SQL)NOTE: For more information about the BACKUP syntax and arguments, see BACKUP (Transact-SQL). 如需 RESTORE 語法和引數的詳細資訊,請分別參閱 RESTORE (Transact-SQL)RESTORE 引數 (Transact-SQL)For more information about the RESTORE syntax and arguments, see RESTORE (Transact-SQL) and RESTORE Arguments (Transact-SQL), respectively.

管理開啟的磁帶Managing open tapes

若要檢視開啟的磁帶裝置清單以及掛載要求的狀態,請查詢 sys.dm_io_backup_tapes 動態管理檢視。To view a list of open tape devices and the status of mount requests, query the sys.dm_io_backup_tapes dynamic management view. 這個檢視顯示所有開啟的磁帶。This view shows all the open tapes. 這包括正在等待下一個 BACKUP 或 RESTORE 作業而暫時閒置的使用中磁帶。These include in-use tapes that are temporarily idle while they wait for the next BACKUP or RESTORE operation.

如果磁帶不慎保持在開啟狀態,釋放磁帶最快速的方式就是使用下列命令:RESTORE REWINDONLY FROM TAPE = backup_device_nameIf a tape has been accidentally left open, the fastest way to release the tape is by using the following command: RESTORE REWINDONLY FROM TAPE =backup_device_name. 如需詳細資訊,請參閱 RESTORE REWINDONLY (Transact-SQL)For more information, see RESTORE REWINDONLY (Transact-SQL).

使用 Azure Blob 儲存體服務Using the Azure Blob Storage service

SQL Server 備份可以寫入 Azure Blob 儲存體服務。SQL Server Backups can be written to the Azure Blob Storage Service. 如需如何針對備份使用 Azure Blob 儲存體服務的詳細資訊,請參閱使用 Microsoft Azure Blob 儲存體服務進行 SQL Server 備份及還原For more information on how to use the Azure Blob storage service for your backups, see SQL Server Backup and Restore with Microsoft Azure Blob Storage Service.

使用邏輯備份裝置Use a logical backup device

「邏輯備份裝置」 (Logical backup device) 是選擇性的使用者自訂名稱,而且它會指向特定的實體備份裝置 (磁碟檔案或磁帶機)。A logical backup device is an optional, user-defined name that points to a specific physical backup device (a disk file or tape drive). 邏輯備份裝置可讓您在參考對應的實體備份裝置時,使用間接取值。A logical backup device lets you use indirection when referencing the corresponding physical backup device.

定義邏輯備份裝置會需要將邏輯名稱指派給實體裝置。Defining a logical backup device involves assigning a logical name to a physical device. 例如,您可以將邏輯裝置 AdventureWorksBackups 定義為指向 Z:\SQLServerBackups\AdventureWorks2012.bak 檔案或 \\.\tape0 磁帶機。For example, a logical device, AdventureWorksBackups, could be defined to point to the Z:\SQLServerBackups\AdventureWorks2012.bak file or the \\.\tape0 tape drive. 備份和還原命令便可以將 AdventureWorksBackups 指定為備份裝置,而不需設定 DISK = 'Z:\SQLServerBackups\AdventureWorks2012.bak' 或 TAPE = '\\.\tape0'。Backup and restore commands can then specify AdventureWorksBackups as the backup device, instead of DISK = 'Z:\SQLServerBackups\AdventureWorks2012.bak' or TAPE = '\\.\tape0'.

邏輯裝置名稱在伺服器執行個體上所有邏輯備份裝置中都必須是唯一的。The logical device name must be unique among all the logical backup devices on the server instance. 若要檢視現有的邏輯裝置名稱,請查詢 sys.backup_devices 目錄檢視。To view the existing logical device names, query the sys.backup_devices catalog view. 這個檢視會顯示每個邏輯備份裝置的名稱,並且描述對應實體備份裝置的類型及實體檔案名稱或路徑。This view displays the name of each logical backup device and describes the type and physical file name or path of the corresponding physical backup device.

定義邏輯備份裝置之後,您就可以在 BACKUP 或 RESTORE 命令中指定邏輯備份裝置來替代裝置的實體名稱。After a logical backup device is defined, in a BACKUP or RESTORE command, you can specify the logical backup device instead of the physical name of the device. 例如,下列陳述式會將 AdventureWorks2012 資料庫備份到 AdventureWorksBackups 邏輯備份裝置。For example, the following statement backs up the AdventureWorks2012 database to the AdventureWorksBackups logical backup device.

BACKUP DATABASE AdventureWorks2012   
   TO AdventureWorksBackups;  
GO  

注意: 在指定的 BACKUP 或 RESTORE 陳述式中,邏輯備份裝置名稱和對應的實體備份裝置名稱是可互換的。NOTE: In a given BACKUP or RESTORE statement, the logical backup device name and the corresponding physical backup device name are interchangeable.

使用邏輯備份裝置的其中一項優點是,它比冗長的路徑名稱更容易使用。One advantage of using a logical backup device is that it is simpler to use than a long path. 如果您打算將一系列備份寫入相同的路徑名稱或磁帶裝置,使用邏輯備份裝置會很有用。Using a logical backup device can help if you plan to write a series of backups to the same path or to a tape device. 邏輯備份裝置對於識別磁帶備份裝置特別有用。Logical backup devices are especially useful for identifying tape backup devices.

您可以撰寫備份指令碼來使用特定的邏輯備份裝置。A backup script can be written to use a particular logical backup device. 這樣您就可以不更新指令碼而切換到新的實體備份裝置。This lets you switch to a new physical backup devices without updating the script. 切換時會涉及下列程序:Switching involves the following process:

  1. 卸除原始邏輯備份裝置。Dropping the original logical backup device.

  2. 定義使用原始邏輯裝置名稱,但對應至不同實體備份裝置的新邏輯備份裝置。Defining a new logical backup device that uses the original logical device name but maps to a different physical backup device. 邏輯備份裝置對於識別磁帶備份裝置特別有用。Logical backup devices are especially useful for identifying tape backup devices.

鏡像備份媒體集Mirrored backup media sets

備份媒體集的鏡像功能可減少備份裝置功能異常時的影響。Mirroring of backup media sets reduces the effect of backup-device malfunctions. 這些功能異常會特別嚴重,因為備份是避免資料遺失的最後一道防線。These malfunctions are especially serious because backups are the last line of defense against data loss. 隨著資料庫大小的成長,備份裝置或媒體故障而導致備份無法還原的可能性也越大。As the sizes of databases grow, the probability increases that a failure of a backup device or media will make a backup nonrestorable. 鏡像備份媒體可透過提供實體備份裝置的備援性,藉以提升備份的可靠性。Mirroring backup media increases the reliability of backups by providing redundancy for the physical backup device. 如需詳細資訊,請參閱本主題稍後的 鏡像備份媒體集 (SQL Server)的使用者閱讀。For more information, see Mirrored Backup Media Sets (SQL Server).

注意: 只有 SQL Server 2005 Enterprise EditionSQL Server 2005 Enterprise Edition 和更新版本才支援鏡像備份媒體集。NOTE: Mirrored backup media sets are supported only in SQL Server 2005 Enterprise EditionSQL Server 2005 Enterprise Edition and later versions.

封存 SQL Server 備份Archive SQL Server backups

建議您使用檔案系統備份公用程式來封存磁碟備份,並將封存保存在異地。We recommend that you use a file system backup utility to archive the disk backups and that you store the archives off-site. 使用磁碟的優點是,您可以使用網路將封存的備份寫入異地磁碟。Using disk has the advantage that you use the network to write the archived backups onto an off-site disk. Azure Blob 儲存體服務可作為異地封存選項。The Azure Blob storage service can be used as off-site archival option. 您可以上傳磁碟備份,或是直接將備份寫入 Azure Blob 儲存體服務中。You can either upload your disk backups, or directly write the backups to the Azure Blob storage service.

另一種常見的封存方法是將 SQL ServerSQL Server 備份寫入本機備份磁碟、將備份封存至磁帶,然後將磁帶存放在異地。Another common archiving approach is to write SQL ServerSQL Server backups onto a local backup disk, archive them to tape, and then store the tapes off-site.

Related tasksRelated tasks

指定磁碟裝置 (SQL Server Management Studio)To specify a disk device (SQL Server Management Studio)

指定磁帶裝置 (SQL Server Management Studio)To specify a tape device (SQL Server Management Studio)

定義邏輯備份裝置To define a logical backup device

使用邏輯備份裝置To use a logical backup device

檢視有關備份裝置的資訊To View Information About Backup Devices

若要刪除邏輯備份裝置To delete a logical backup device

另請參閱See also

SQL Server 的 Backup Device 物件 SQL Server, Backup Device Object
BACKUP (Transact-SQL) BACKUP (Transact-SQL)
維護計畫 Maintenance Plans
媒體集、媒體家族與備份組 (SQL Server) Media Sets, Media Families, and Backup Sets (SQL Server)
RESTORE (Transact-SQL) RESTORE (Transact-SQL)
RESTORE LABELONLY (Transact-SQL) RESTORE LABELONLY (Transact-SQL)
sys.backup_devices (Transact-SQL) sys.backup_devices (Transact-SQL)
sys.dm_io_backup_tapes (Transact-SQL) sys.dm_io_backup_tapes (Transact-SQL)
鏡像備份媒體集 (SQL Server)Mirrored Backup Media Sets (SQL Server)