Maintenance and Monitoring - Microsoft SQL Server 2008 R2 Administration - page 332

10. The result will be as follows:

Name State_desc Physical_name
PMDB_PRIMARY ONLINE C:\Program Files\Microsoft SQL Server\

MSSQL10_50.SQL2K8R2U\MSSQL\DATA\PMDB_
Primary.mdf

PMDB_log ONLINE C:\Program Files\Microsoft SQL Server\

MSSQL10_50.SQL2K8R2U\MSSQL\DATA\PMDB_log.
ldf

PMDB_
Secondary

RECOVERY_
PENDING

C:\Program Files\Microsoft SQL Server\
MSSQL10_50.SQL2K8R2U\MSSQL\DATA\PMDB_
Secondary.ndf

PMDB_
Tertiary

RECOVERY_
PENDING

C:\Program Files\Microsoft SQL Server\
MSSQL10_50.SQL2K8R2U\MSSQL\DATA\PMDB_
Tertiary.ndf

10. Now, we have a PARTIAL availability of PieceMealDB database to verify execute
SELECT * from dbo.Address statement that will present the following error:
Msg 8653, Level 16, State 1, Line 1
The query processor is unable to produce a plan for the table or
view 'Address' because the table resides in a filegroup which is
not online.

Now, let us proceed to restore a PAGE to recover data pages that have become
corrupted due to a disk problem.

11. The process for restoring specific pages is similar to restoring a filegroup or database
or file. We can find the corrupted pages from the system database table msdb.dbo.
suspect_pages or refer to SQL Server error log or a result from the database
consistency checks ( DBCC ) process.

It is highly recommended to execute the DBCC
CHECKDB statement periodically and review results
that will highlight all the irregular pages information.

12. To restore the page, we will use the full database backup file
PieceMealFullDatabaseBackup.bak and transaction log backup file
PieceMeal_TlogAfterBackup.bak that was created in earlier steps.