Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

One of the databases appeared invalid

Options
  • 03-03-2018 4:47pm
    #1
    adadelgado
    Registered Users Posts: 1 ✭


    I work on SQL Server 2008 R2. It is quite old version, but it's very reliable. I manage numerous of databases every day, it's my job. One of them gave me a lot of trouble some days ago. I only opened it and SQL viewed SQL Server Page Level Corruption. I checked it once more the same error remained. I hope, here there are users who knows how to overcome this...


Comments

  • Options
    #2
    amen
    Registered Users Posts: 2,781 ✭✭✭amen


    You are have two options here.

    1: DBCC but me careful as you may loose data
    2: Restore from you backups and roll forward your transaction logs but depending on your log backup frequency you may loose data.

    If you are not sure what you are doing and data is business critical I would suggest contacting your organisations DBA team.


  • Options
    #3
    nullObjects
    Registered Users Posts: 1,311 ✭✭✭nullObjects


    I'd echo the above.

    There should also be a log file you can check to see what caused the error.
    It might be worth checking it now before it's gone in case it's set to roll over or be removed every couple of days.


  • Options
    #4
    Sheldgallagh
    Registered Users Posts: 6 ✭Sheldgallagh


    There are three different ways to recover the database.
    1) Recover the database manually with following command.
    RESTORE DATABASE database_name WITH RECOVERY
    2) Recover the database with the last log file.
    RESTORE LOG database_name FROM backup_device WITH RECOVERY
    3) Recover the database when bak is restored
    RESTORE DATABASE database_name FROM backup_device WITH RECOVERY
    One more variant might be using knowledge bases on this question from Microsoft and other useful resources
    https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/restore-and-recovery-overview-sql-server
    https://www.mssqltips.com/sqlservertutorial/2/sql-server-recovery-models/
    https://sql.recoverytoolbox.com/


Advertisement