70-450 Question #132: Real Exam Question with Answer & Explanation

You are a professional level SQL Sever 2008 Database Administrator. A large database is hosted by the instance. The company utilizes the following backup strategy for the database. First, the performance of a full database backup is implemented at 02:00 hr every Monday. Secondly, the performance of a differential backup is implemented at 23:00 hr every day. Thirdly, the performance of a transaction log backup is implemented on an hourly basis. A reboot is caused on the SQL Server 2008 server by a power failure at 09:15 hr, Thursday. Fifteen minutes after the reboot of the server, it is reported that certain queries that access customer data cannot be executed. You find that the customer data remains unvaried after the power failure. When the DBCC CHECKDB command is executed on the database, the following error message is received. Object ID 2814307832, index ID 2, partition ID 83127819437122157, alloc unit ID 82134587923221126 (type In-row data): Page (3421:169) could not be processed. See other errors for details. Table error: Object ID 2814307832, index ID 2, partition ID 83127819437122157, alloc unit ID 82134587923221126 (type In-row data), page (3421:169). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 16928422 and -8.CHECKDB found 0 allocation errors and 2 consistency errors in table 'tbl_Customer' (object ID 2814307832). When the sp_help 'tbl_customer' stored procedure is executed, the following result set is received: index_name index_description PK clustered located on PRIMARY NCIX nonclustered located on PRIMARY Since you are the technical support, you are required to make sure that the data should be accessible in the shortest time. And the impact on users should be cut to the least. Which action will you perform to finish the task?