gptkbp:instanceOf
|
database backup process
|
gptkbp:broadcastOn
|
yes
|
gptkbp:canAutomate
|
gptkb:SQL_Server_Agent
PowerShell scripts
Maintenance Plans
|
gptkbp:canBe
|
development
testing
database migration
RESTORE FILELISTONLY
RESTORE HEADERONLY
RESTORE VERIFYONLY
|
gptkbp:canBeInitiatedWith
|
gptkb:PowerShell
BACKUP DATABASE command
Maintenance Plan Wizard
SQL Server Management Studio GUI
|
gptkbp:canRestore
|
different server
same server
RESTORE command
cloud environment
|
gptkbp:canStore
|
gptkb:Amazon_S3
gptkb:Google_Cloud_Storage
gptkb:Azure_Blob_Storage
cloud storage
tape
local disk
network share
|
gptkbp:compressionRatio
|
yes
|
gptkbp:criticalFor
|
gptkb:legislation
business continuity
|
gptkbp:encryption
|
yes
|
https://www.w3.org/2000/01/rdf-schema#label
|
SQL Server backup
|
gptkbp:introducedIn
|
gptkb:SQL_Server_7.0
|
gptkbp:monitors
|
gptkb:SQL_Server_Management_Studio
third-party tools
|
gptkbp:pointInTime
|
yes
|
gptkbp:purpose
|
data protection
disaster recovery
|
gptkbp:requires
|
sufficient disk space
appropriate permissions
|
gptkbp:storedAs
|
.bak file
.dif file
.trn file
|
gptkbp:supportedBy
|
gptkb:SQL_Server_Management_Studio
gptkb:Transact-SQL
|
gptkbp:type
|
differential backup
file backup
full backup
copy-only backup
filegroup backup
transaction log backup
|
gptkbp:usedBy
|
gptkb:Microsoft_SQL_Server
|
gptkbp:bfsParent
|
gptkb:Carbonite_Server
gptkb:System_Center_Data_Protection_Manager
|
gptkbp:bfsLayer
|
7
|