ln_options: Table is marked as crashed and last repair failed

  • Nasim

    (@nasimburnpur)


    6 years, 1 month ago

    i am just a beginner just help me out from this problem

    ln_options: Table is marked as crashed and last repair failed

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Moderator t-p

    (@t-p)

    Do you have a good backup of your database? If you do, try storing it.

    If not, ask your hosting provider if they have a backup of your site. If they do, ask them to restore it.

    I agree with the above answer, restore the database from updated backup. If you don’t have the updated backup then, you can also repair the database by using DBCC CHECKDB Repair option. 

    User master
DBCC CHECKDB ('YourDatabaseName',REPAIR_ALLOW_DATA_LOSS)

    As Microsoft says, you may lose some data with this command. In this case, you can go with a SQL recovery software. One of my friend Damian Widera (SQL MVP) done the review of a software. Read the review from here: https://sqlblog.com/blogs/damian_widera/archive/2015/08/24/stellar-phoenix-sql-database-repair-first-look-review.aspx

    Good Luck!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘ln_options: Table is marked as crashed and last repair failed’ is closed to new replies.

Tags