backupstatus

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
BackupID INT 10 √ null
backuplogs.BackupID Implied ConstraintR
v_ltcr_backuplogs.BackupID Implied ConstraintR
ComputerID INT 10 null
JobID INT 10 null
backupjobs.JobID Implied ConstraintR
DestinationID INT 10 null
backupdestinations.DestinationID Implied ConstraintR
ImageName VARCHAR 255 null
ImageSize BIGINT 19 null
BackupEngine INT 10 null
GroupJobID INT 10 null
groupbackupjobs.GroupJobID Implied ConstraintR
LocationJobID INT 10 null
locationbackupjobs.LocationJobID Implied ConstraintR
DriveID INT 10 null
Status INT 10 null
Message VARCHAR 255 null
LastRunDate DATETIME 19 null
Details TEXT 65535 null
Enabled INT 10 null
BackupTime TIME 8 null
TargetComputerId INT 10 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc BackupID
ComputerID Performance Asc ComputerID
DestinationID Performance Asc DestinationID
GroupID Performance Asc GroupJobID
JobID Performance Asc JobID

Relationships

Close relationships within degrees of separation