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.

Firefox ad block