Hence, let’s start with the basic types – a simple recovery model and a full recovery model. I suggest we explore each restore type in greater detail. The page restore applies to any database, no matter the number of filegroups. A data page recovery allows restoring separate databases when using the full restore model or the incomplete logging model.Any attempts to use the offline files and filegroups cause errors. During the file restoration process, all file groups that contain the processed files are switched to offline mode for the time of restore. A database file recovery suggests that a data file or a file set reverts to its original state and is restored.Note that the database is in offline mode during the revert and restore operations. A full database recovery suggests that the entire database reverts to the previous state and is restored.Database Recovery TypesĪs this article deals with the data restore process, let me present the three main types of database recovery: To start with, let me remind you that in the first and the second articles, we reviewed the basics of the SQL Server backup process, main backup types, and the approaches to performing an auto backup. The third article in the series about SQL Server backup and restore will take us through the database restore process and demonstrate the two main principles of database restore available in Microsoft.

Sql back up master