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. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |