A logfile is an important component in a Database. The log file is part of a lot of operations in a database such as Writing to the Database, Transactions, Recovery. Further, there are important features that can be utilized with log files such as Replication, Mirroring, and Log Shipping.
Due to the many usages of the Transaction Log file, it is important to understand the behaviour of the transaction log file. The transaction log behaviour will be determined by the Recover Models which are discussed in this article.
The Transaction Log file is extremely useful to handle Point in Time Recovery in live or production environments to recover from accidental data deletes and other operations. This article describes how to configure point in time recovery. Further, log shipping can be configured to enable data disaster recovery.
In the later version of SQL Server, provides the mechanism to customized Transaction Log Backups.
No comments:
Post a Comment