Back up Types

Three types of back up :

Full

Differential

Transnational

Full
As the name suggests, Full Copy involves taking back up of all the database this also includes log files, this enables to restore database to the state where the backup was taken

Differential

This involves taking the copy of the latest changed data, a Differential backup on top of a full back up allows to restore a database, differential back ups are small, faster and prevent the data loss in case of data corruption, very useful if a part of database is modified more as compared to whole of the database.

Transnational

Allows to backup the active transaction log when Full or Bulk Logged recovery model is set, so by any means the data is corrupted we can restore it to the last state where the data integrity was upheld. i’ll explain this in another post.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s