SQL Server: Backup Basics

SQL server backups are essential no matter how simple or complex your database is. Getting SQL Server Backups right is the most important thing that you can do to keep your database intact. An inappropriate, untested,or missing backups can cause an entire business to fail.

Backups within SQL Server are affected by transactions and transaction log management. These methods of transaction are controlled by the database recovery models and these are:

Simple: Transactions are written into the log.

Bulk-logged: All transactions are written to the log except certain types.

Full: All transactions are written to the log.

Here is a quick guide on the basics of SQL Server Backups: https://www.simple-talk.com/sql/backup-and-recovery/sql-server-2014-backup-basics/

Leave a Reply

Your email address will not be published. Required fields are marked *