The following requirements and limitations exist when perform page-level restores:

• Pages can be restored from the following backup types: Database, filegroup, file, read-write filegroups, partial database.

• Your SQL Server 2005 or later database must use either the full or bulk-logged recovery model. Use this model in order for page-level restore to be available to you.

• SQL Server sometimes cannot recover the specific pages that you request if they contain critical information about the definition of the database itself. For example, you cannot use page-level restore for the first page in a database file. When you detect that page-level restore does not work, you need to use full database recovery.

• A maximum of 1000 pages can be recovered from a backup image through a page-level restore.