Lohn Solutions

 Backups and Backup StrategiesMicrosoft’s SQL Server Backup Overview

  http://msdn.microsoft.com/en-us/library/ms175477.aspx

  What we use (all definitions taken from link above):

  1.  Full backups

  A full backup contains all the data in a specific database or set of  filegroups or files, and [...]

General DBA Responsibilities

Availability/Recoverability
Security
Performance
Develop/Deploy

  RecoverabilityRecoverability means that, if a data entry error, program bug or hardware failure occurs, the DBA can bring the database backward in time to its state at an instant of logical consistency before the damage was done. Recoverability activities include making database backups and storing them in ways that minimize the [...]