SQL Server Backup Info: Memory

Memory components - Buffer Cache and Log Cache.

Buffer Cache – Within the buffer cache are a pool of buffer pages into which data pages are read. This is where data can be modified.

Log Cache – Within the log cache are buffer pages. Whenever a change is made to a record within the buffer cache, a corresponding log record is put into the log cache to record the modification as well as the transaction recording the modification.

  Oracle Backup Info

  :: Coming Soon

  Oracle Exercises

  :: Coming Soon

  SQL Server Backup Info

  :: Overview
  :: Types of Failure
  :: System Databases
  :: Recovery Models
  :: Backup Types
  :: Database Files
  :: Memory
  :: Configuration
  :: Troubleshooting
  :: msdb Tables
  :: SQL Server Links

  SQL Server Exercises

  :: Create Backup Device
  :: Database Backup
  :: Lost Database - Simple
  :: Lost Database - Full
  :: Lost Primary - Full
  :: Lost Secondary - Full
  :: Rebuild Master
  :: Restore MSDB
  :: Restore Model, Tempdb
  :: Attach and Detach DB
  :: Point in Time Recovery
  :: Using Marks
  :: DBCC CHECKDB
  :: Verifying Backups
  :: Restricted Modes
  :: Alter Recovery Model
  :: Stored Procs
dbarecovery.com title
lightning strike
sunrise over Yellowstone Lake