Sub Account
Day Begin Issues And Solution
While day
begin into Subaccount it may show the error message like below due to
corruption of tables in SQL databases.
Run-time error
Microsoft – ODBC SQL Server
Driver – SQL Server – I?O error ( bad page ID) deleted during read at offset
0x0000000572e000 in file ‘ C:\BOSUBACCOUNTS_dat.mdg’.
Solution
- Running CHECKDB with
REPAIR_ALLOW_DATA_LOSS will definitely be able to fix this issue - but to
for this error it will simply delete the broken page. In this case, the
page is a data page so will definitely lose data.
- If you
have a backup, you should restore from it to avoid losing data.
Note :A torn-page (as referenced in the error) can happen
when a power-failure occurs during transaction processing and one of the drives
loses power in the middle of a write operation
