Database can't be opened

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.

1 Like

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/

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.