17
Data unavailable: Unable to complete because the required data is currently unavailable. The command failed and the transaction aborted. Try again later or contact your System Administrator.
The recovery fault isolation (RFI) feature enables recovery to mark a single page or a set of pages of a user database suspect, while allowing access to the remainder of the database. The bad pages are said to be “offline,” and may not be used until the problem is corrected.
Error 12716 is raised when you issue a query that requires
access to an offline page. This error is followed by error 12717
(Suspect data encountered: Database '%.*s',
object '%.*s', index ID '%ld', page ID
'%ld'.).
The offline pages must be repaired before they can be used. Responsibility for repairing offline pages belongs to a user with sa_role. The System Administrator can bring a page online to make it accessible to sa_role:
1> sp_forceonline_page <database_name>, <pgid>, 'sa_on' 2> go
Where <pgid> is the page ID shown in the accompanying 12717 error.
WARNING! When forcing pages online, Adaptive Server does not perform any consistency checks before the pages are forced online.
Use existing methods to diagnose and repair problems, checking the server error log for any errors related to the offline page and determining appropriate corrective action. Before making repaired pages available to all users, check that repairs have been made correctly by running dbcc commands or queries with known results.
For a detailed discussion of RFI, refer to “Online recovery and fault isolation” in the chapter “Server Recovery Tasks” in the most recent version of Troubleshooting and Disaster Recovery.
All versions
