What is Database Backup ?

 What is Database Backup ?

• The word backup refers to copying and archiving the data so that it may be used to

restore in case of an event of data loss. In general, you should back up any work or data

that can’t be replaced easily.

• A database backup is a copy of data from the database, which can be used to reconstruct

the data.

• A database backup is a process to protect the data from various disasters. Disasters

cannot be completely prevented; the least we can do is to ensure we have everything

that’s needed to get up and running as soon as we can.

• Organizations target for backup, the data they feel is vulnerable to:

• Corruption

• Failed hardware including media failure, software failure, and OS errors

• Attacks on the network or other malicious actions

• Manual errors or other inadvertent actions

• Unauthorized changes

• and other undesirable events

SQL Server Backup Types

• Full backups

• Differential backups

• Transaction log backups

• File backups

• Filegroup backups

• Partial backups

• Copy-Only backups

• Mirror back