SQL Server backup

GPTKB entity

Statements (54)
Predicate Object
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