SQL Database Error : Sub Account Day Begin Error

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.

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