Storage Engine

The main responsibilities of the storage engine include:

• Managing the files on which the database is stored and managing the use of space in the files.
  
  
• Building and reading the physical pages used to store data.
  
  
• Managing the data buffers and all I/O to the physical files.
  
  
• Controlling concurrency. Managing transactions and using locking to control concurrent user access to rows in the database.
  
  
• Logging and recovery.
  
  
• Implementing utility functions such as the BACKUP, RESTORE, and DBCC statements and bulk copy.