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 indexWhat 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.
|