The transaction log keeps a before and after image of each change made in the database. Microsoft SQL Server keeps a transaction log for each database.
Back up the transaction log frequently. This keeps the transaction log small and reduces the amount of data lost in the event of a severe database corruption.
|
Copyright © 2013 CA.
All rights reserved.
|
|