Chapter 11: Developing a Backup and Recovery Plan  Using delayed_commit to determine when log records are committed

Chapter 11: Developing a Backup and Recovery Plan

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! Never use insert, update, or delete commands to modify syslogs.





Copyright © 2005. Sybase Inc. All rights reserved. Using delayed_commit to determine when log records are committed

View this book as PDF