Your database is corrupt. Restore it from the last known good backup.
If you don't have a backup (why not?!)
, then you might be able to use one of the repair options:
The output from the
command will tell you the minimum repair level required. If you're lucky, it will be
, which will attempt to fix the corruption without deleting any data. Otherwise, you'll be stuck with
, which will delete data and break referential integrity to try to fix the corruption.
Make sure you run
after any repair operation.
Once your database is back to a usable state, set up a job to back your database up on a regular basis. Make sure you regularly test the backups to ensure that you can restore them if necessary.