![]() ![]() Three recovery models exist: simple, full, and bulk-logged. Recovery model: A database property that controls transaction log maintenance on a database. In addition to data backups, the full recovery model requires creating backups of the transaction log. A backup of SQL Server data is created at the level of a database or one or more of its files or filegroups. Termsīack up : Copies 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.īackup : A 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 article introduces the SQL Server backup component.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |