SQL Server Backup
Microsoft SQL Server is a relational model database server produced by Microsoft. Its primary query languages are T-SQL and ANSI SQL.
Microsoft SQL Server enables users to back up and restore their databases. The SQL Server backup and restore component provides an important safeguard for protecting critical data stored in SQL Server databases. A well-planned backup and restore strategy helps protect databases against data loss caused by a variety of failures.
A copy of data that can be used to restore and recover the data is called a backup. Backups let users restore data after a failure. Additionally, backups of a database are useful for routine administrative purposes, such as copying a database from one server to another, setting up database mirroring and archiving.
The scope of a backup of data (a data backup) can be a whole database, a partial database, or a set of files or file groups. For each of these, SQL Server supports full and differential backups. A full backup contains all the data in a specific database or set of file groups or files, and also enough log to allow the recovery of that data. A differential backup is based on the latest full backup of the data. This is known as the base of the differential, or the differential base. Usually, a differential base is used by several successive differential backups. At restore time, the full backup is restored first, followed by the most recent differential backup.
In This Section
Follow AppAssure
Free Software Tools
Latest eBook Chapter
Chapter 1: Introduction: Why the Backup 1.0 Mentality is Killing You
Series: The Definitive Guide Series
Author: Don Jones
ISBN: pending
Synopsis:
The first backup—technically—was around 1951, when the first generation of digital computing appeared in the form of UNIVAC I. The “backups,” such as they were, were the punch cards used to feed instructions to the massive [...]
