Developer Bloq

First : DBCC CHECKDB (’DatabaseName’) — this command is list of database errors

Second: DBCC CHECKDB (’DatabaseName’, REPAIR_REBUILD) — if first command is return errors than execute this command. This command is repair successful of database.

Third: DBCC CHECKDB (’DatabaseName’, REPAIR_ALLOW_DATA_LOSS) — if second command is return errors than you may use this command but this command is dangerious because it’s make data loss for minimum damage. Run this command when absolutely create a backup.