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 |