SQL DB Backup restoration error RRS feed

  • Question

  • Hi Friends,

    Can I get help on the below issue during backup restoration.

    Msg 1813, Level 16, State 2, Line 1
    Could not open new database 'DBname'. CREATE DATABASE is aborted.
    Msg 824, Level 24, State 2, Line 1
    SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:127634; actual 0:0). It occurred during a read of page (1:127634) in database ID 5 at offset 0x0000003e524000 in file 'DB Path DBname.mdf'.  Additional messages in the SQL Server error log or operating system error log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online

    Wednesday, November 4, 2020 7:47 AM

All replies