1. Backup is taken in the night at 7pm
2. If users update the data at 9am (next day). Ex: UPDATE Employee SET EmpNo = 2 WHERE EmpNo = 1. This data is residing on Page - 1:88 .
3. Data page (1:88) is corrupted at 10am.
If I follow your recommendations and after troubleshooting it successfully:
1. What will be the value of EmpNo? Is it 1 or 2?
A1 It will be 1, later you can
2. If it 1 then what will happen to the dependancies of Employee table? Assume, there is a trigger on Employee table which updates the EmpNo in the other tables as and when EmpNo is updated in the Employee table.
<a href='http://' class='authorlink' target='_blank'></a>