Damage of the SQL database

[gioacchinolupi]

 Good day, friends!

There is the following situation.  On one server, I make a backup of the database. With integrity check everything is carried out. Transfer the backup to another server and restore from it base, has also successfully completed. I do a couple of selects from the tables just in case, selects are work. After that didn't touch base. Suddenly after a few hours started pouring in an error like

Table error: alloc unit ID 72057606917455872, page (1:1163817) contains an incorrect page ID in its page header. The PageId in the page header = (1:8696745).

Doing DBCC CHECKDB but it fails.

Msg 7985, Level 16, State 2, Line 1

System table pre-checks: Object ID 3. Could not read and latch page (1:1163817) with latch type SH. Check statement terminated due to unrepairable error.

DBCC results for 'DWH_Globus'.

Msg 5256, Level 16, State 1, Line 1

Table error: alloc unit ID 72057606917455872, page (1:1163817) contains an incorrect page ID in its page header. The PageId in the page header = (1:8696745).

CHECKDB found 0 allocation errors and 1 consistency errors not associated with any single object.

CHECKDB found 0 allocation errors and 1 consistency errors in database 'DWH_Globus'.

ObjectId 3 - system table. I don't know how it could be damaged. To SAN there were no errors. In Event Viewer there are no errors, except these.

ОС - WinServer 2012 R2, SQL Server 2012 SP2 CU4 EE. 

Except me nobody touched base.  Prompt, please, because of what such can happen not to run on the same mistakes next time.  

[TimothyCarr]

Technically it is possible. Could make a restoration option with truncation of not used space in the file. Try when working with low free disk space on the test server when you turn the database in there manually,  truncate the transaction log on the productions. and  only  then take a full backup  for deploy to a test server.   Still here look information  

http://www.filerepairforum.com/forum/microsoft/microsoft-aa/sql-server/1914-restore-the-sql-server-database

[gioacchinolupi]

Thanks for the advice. Your link was very useful for me! Thank you! Solved!