Transaction Log Architecture Backups

Transaction Log Architecture Backups.

Transaction log records all transactions and the database modifications made by each transaction.

Transaction log helps in:
- Recovering individual transaction in case of failures
- Helps in recovering incomplete transactions if a running SQL server fails.
- It helps to restore the database to the point where it failed.
- The transaction log is a separate file or set of files.

The transaction log cache is managed separately from the data pages making it robust
File and Filegroup Backups
File or Filegroup backups support backing up and restoring individual files or filegroups. This is usually used in very large database.......
What is cursor in SQL Server?
A Cursor is a database object that represents a result set and is used to manipulate data row by row........
Define the steps to use Transact-SQL Cursor
Declare the cursor, Open the cursor, Fetch record row by row, Close cursor, Deallocate cursor........
Post your comment

Related Content

Follow us

▲