SQL Server restore and recovery supports restoring data from a backup of a whole database, a data file or a data page as follows: the whole database is restored and recovered and the database is offline for the duration of restore and recovery operations.