What are the events recorded in a transaction log?

What are the events recorded in a transaction log?

The start and end of each transaction
Every data modification
Every extent allocation or deallocation
The creation or dropping of a table or index

What are the events recorded in a transaction log?

Events recorded in a transaction log:
-Broker event category includes events produced by Service Broker.
-Cursors event category includes cursor operations events.
- CLR event category includes events fired by .Net CLR objects.
- Database event category includes events of data.log files shrinking or growing on their own.
- Errors and Warning event category includes SQL Server warnings and errors.
- Full text event category include events occurred when text searches are started, interrupted, or stopped.
- Locks event category includes events caused when a lock is acquired, released, or cancelled.
- Object event category includes events of database objects being created, updated or deleted.
- OLEDB event category includes events caused by OLEDB calls.
- Performance event category includes events caused by DML operators.
- Progress report event category includes Online index operation events.
- Scans event category includes events notifying table/index scanning.
- Security audit event category includes audit server activities.
- Server event category includes server events.
- Sessions event category includes connecting and disconnecting events of clients to SQL Server.
- Stored procedures event category includes events of execution of Stored procedures.
- Transactions event category includes events related to transactions.
- TSQL event category includes events generated while executing TSQL statements.
- User configurable event category includes user defined events.
Describe when checkpoints are created in a transaction log.
SQL server transaction log - It is created when CHECKPOINT statement is executed........
SQL Server - Truncate and Delete
Truncate and Delete commands - Truncate command is used to remove all rows of the column....
SQL Server Lock Types
SQL Server Lock Types - In this section, we have covered SQL Server lock types.....
Post your comment