As described above, the database can be restored to the state prior to transaction that involves selected operation. The table below lists the SQL Server database operations and their display names that appear in the process of fine-tuning database restore.
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> |
|
