DBCC CheckDB

Dynamics 365 Business Central/NAV Technical Forum
1

Hi ,

Any body know what are allocation errors in SQL server … when running DBCC CHECKDB …

How can i solve the problem if i have 3 allocation errors

CHECKDB found 3 allocation errors and 0 consistency errors in database ‘testing datbase’.repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (testing database).

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

2

The solution is to do backup from navision … where we have to wait a long time if the database is big ,

the do a new database from navision and not from sql … the restore it from navision also it will take a long time …

then when you do DBCC CHECKDB … you will not have more errors …