I'm a novice as administrator of SQL Server databases. Today I firstly visited my new job and of course, I got some problems. One of our databases has denied opening, it has only opened with message - Metadata corruption Error. I've no idea what does it mean, I only know, that this forum might be helpful for me. I'm on SQL Server 2017 and on Windows 10 x64.
You'll likely have to restore it from backup. It's corrupted
It might be page level corruption or the corruption in header. take a look on this blog to know how to fix SQL Server page level corruption: http://www.sqlmvp.org/fixing-sql-server-page-level-corruption-error/
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.