The transaction log supports the following operations:
- Recovery of individual transactions.
- Recovery of all incomplete transactions when SQL Server is started.
- Rolling a restored database, file, filegroup, or page forward to the point of failure.
- Supporting transactional replication.
- Supporting high availability and disaster recovery solutions: AlwaysOn Availability Groups, database mirroring, and log shipping.
No comments:
Post a Comment