MSSQL: Tracking Pages Recovery and restoring

Tracking Pages Recovery and restoring

Prerequisite
The database must be FULL or Bulk-logged Recovery Model.

To save time and reducing further I/O contentions on the database by running DBCC CHECKDB, we can use PHYSICAL_ONLY.

DBCC CHECKDB WITH PHYSICAL_ONLY
RESTORE DATABASE VCDB_2016 PAGE='2:42' FROM BACKUP WITH NORECOVERY.

This can be achieved with GUI as well.

1. Right Click at the database needs to be restored.
2. Select Task - Pages