Getting Information About the Transaction Log

The transaction log contains enough information about each transaction to ensure that it can be recovered.

Use the dump transaction command to copy the information it contains to tape or disk. Use sp_spaceused syslogs to check the size of the log, or sp_helpsegment logsegment to check the space available for log growth.

Warning!   Do not use insert, update, or delete commands to modify syslogs.