backupset: SQL Server
insert update delete
- Katalog:
msdb - Schema:
dbo - Primärschlüssel:
backup_set_id
Mit insert, update und delete können Daten abgerufen und geändert werden.
Tabellenspalten
Die Spalten der Tabelle backupset sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.
| Name | Datentyp | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
backup_ |
datetime |
||||
backup_ |
int32 |
||||
backup_ |
guid |
||||
backup_ |
decimal |
||||
backup_ |
datetime |
||||
begins_ |
char |
||||
catalog_ |
int16 |
||||
catalog_ |
int16 |
||||
checkpoint_ |
decimal |
||||
code_ |
int16 |
||||
collation_ |
varchar2 |
||||
compatibility_ |
int16 |
||||
compressed_ |
decimal |
||||
database_ |
decimal |
||||
database_ |
datetime |
||||
database_ |
guid |
||||
database_ |
varchar2 |
||||
database_ |
int32 |
||||
description |
varchar2 |
||||
differential_ |
guid |
||||
differential_ |
decimal |
||||
encryptor_ |
blob |
||||
encryptor_ |
varchar2 |
||||
expiration_ |
datetime |
||||
family_ |
guid |
||||
first_ |
int16 |
||||
first_ |
decimal |
||||
first_ |
int16 |
||||
first_ |
guid |
||||
flags |
int32 |
||||
fork_ |
decimal |
||||
has_ |
char |
||||
has_ |
char |
||||
has_ |
char |
||||
is_ |
char |
||||
is_ |
char |
||||
is_ |
char |
||||
is_ |
char |
||||
is_ |
char |
||||
is_ |
char |
||||
is_ |
char |
||||
key_ |
varchar2 |
||||
last_ |
int16 |
||||
last_ |
decimal |
||||
last_ |
int16 |
||||
last_ |
guid |
||||
machine_ |
varchar2 |
||||
media_ |
int32 |
||||
mtf_ |
int16 |
||||
name |
varchar2 |
||||
position |
int32 |
||||
recovery_ |
varchar2 |
||||
server_ |
varchar2 |
||||
software_ |
int16 |
||||
software_ |
int16 |
||||
software_ |
int16 |
||||
software_ |
int32 |
||||
sort_ |
int16 |
||||
time_ |
int16 |
||||
type |
char |
||||
unicode_ |
int32 |
||||
unicode_ |
int32 |
||||
user_ |
varchar2 |