Help Center
Choose product document...
Veeam Backup & Replication 9.5
Veeam Backup Explorers User Guide

SQL Database Operation Selection

The following table contains SQL Server database operations and their display names that appear in the fine-tuning database restore dialog.

Entity

Operation

Display Format

Constraints

Table

CREATE

<date_time> Created[/Modified] <table_name> Table <table ID> <initiator>

 

DROP

<date_time> Deleted <table_name> Table <table ID> <initiator>

 

ALTER

<date_time> Column added <table_name> Table <table ID> <initiator>

 

INSERT INTO

<date_time> Inserted row <table_name>[/table_ID] Table <initiator>

Table name will not be displayed for deleted table, only table ID will be shown.

DELETE FROM

<date_time> Deleted row <table_name>[/table_ID] Table <initiator>

Table name will not be displayed for deleted table, only table ID will be shown.

UPDATE

<date_time> Modified <table_name>>[/table_ID]  Table <initiator>

Table name will not be displayed for deleted table, only table ID will be shown.

TRUNCATE

<date_time> Truncated Table <initiator>

Table name and ID will not be displayed for deleted table.

BULK INSERT

<date_time> Inserted row <table_name>[/table_ID] Table <initiator>

 

View

CREATE

<date_time> Created <view_name> View <initiator>

 

DROP

<date_time> Deleted <view_name> Table <initiator>

 

ALTER

<date_time> Modified <view_name> View <initiator>

 

Index

CREATE

<date_time> Created <index_name> Index <initiator>

 

DROP

<date_time> Deleted <index_name> Index <initiator>

 

ALTER

<date_time> Modified <index_name> Index <initiator>

 

Procedure

CREATE

<date_time> Created <procedure_name> Procedure <initiator>

 

DROP

<date_time> Deleted <procedure_name> Table <initiator>

 

ALTER

<date_time> Modified <procedure_name> Procedure <initiator>

 

Function

CREATE

<date_time> Created <function_name> Function <initiator>

 

DROP

<date_time> Deleted <function_name> Table <initiator>

 

ALTER

<date_time> Modified <function_name> Function <initiator>

 

Schema

CREATE

<date_time> Created <schema_name> Schema <initiator>

 

DROP

<date_time> Deleted <schema_name> Schema <initiator>

 

ALTER

<date_time> Modified <schema_name> Schema <initiator>

Schema cannot be detected.

User

CREATE

<date_time> Created <user_name> User <initiator>

 

DROP

<date_time> Deleted <user_name> User <initiator>

 

ALTER

<date_time> Modified <user_name> User <initiator>

 

Trigger

CREATE

<date_time> Created <trigger_name> Trigger <initiator>

 

DROP

<date_time> Deleted <trigger_name> Trigger <initiator>

 

ALTER

<date_time> Modified <trigger_name> Trigger <initiator>

 

Veeam Large Logo

User Guide for VMware vSphere

User Guide for Microsoft Hyper-V

Enterprise Manager User Guide

Veeam Cloud Connect Guide

Veeam Agent Management Guide

Veeam Backup Explorers User Guide

PowerShell Reference

RESTful API Reference

Veeam Backup FREE Edition User Guide

Veeam Backup for Microsoft Office 365

Veeam ONE Documentation

Veeam Agent for Windows Documentation

Veeam Agent for Linux Documentation

Veeam Management Pack Documentation