![]() Types of backupsĪ special-use backup that is independent of the regular sequence of SQL Server backups.Ī backup of data in a complete database (a database backup), a partial database (a partial backup), or a set of data files or filegroups (a file backup).Ī backup of a database. ![]() The recovery model of database determines its backup and restore requirements.Ī multi-phase process that copies all the data and log pages from a specified SQL Server backup to a specified database, and then rolls forward all the transactions that are logged in the backup by applying logged changes to bring the data forward in time. Three recovery models exist: simple, full, and bulk-logged. In addition to data backups, the full recovery model requires creating backups of the transaction log.Ī database property that controls transaction log maintenance on a database. A backup of SQL Server data is created at the level of a database or one or more of its files or filegroups. TermsĬopies the data or log records from a SQL Server database or its transaction log to a backup device, such as a disk, to create a data backup or log backup.Ī copy of SQL Server data that can be used to restore and recover the data after a failure. The topic also introduces SQL Server backup devices and backup media. This discussion covers backup types, and backup restrictions. ![]() Backing up your SQL Server database is essential for protecting your data. This topic introduces the SQL Server backup component.
0 Comments
Leave a Reply. |