Different types of Backups?

There are Four different types of backups:

1)A full database backup is a full copy of the database.
2)A transaction log backup copies only the transaction log.
3)A differential backup copies only the database pages modified after the last full database backup.
4)A file or filegroup restore allows the recovery of just the portion of a database that was on the failed disk.


No responses found. Be the first to comment...

  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name: