G
G
genek962017-11-04 12:12:28
SQL Server
genek96, 2017-11-04 12:12:28

What should I do if, when restoring a database, Microsoft SQL Server 2012 gives an error "failed to read data" at about 65% of progress?

Restored the working database to yesterday's state. During the recovery, it began to give an error "error reading data". The working base itself is stuck in the recovery state. An attempt to display it with the query "restore database [name_db] with recovery" ends with another error The database cannot be recovered because the log was not restored. How to restore at least some version of the database?
Full text of the first error:
System.Data.SqlClient.SqlError: Read on "E:\Other Exchange\SQLBase\Lombard2015\Lombard2015_backup_2017_11_02_230009_7349536.bak" failed: 23(Data error (CRC).) (Microsoft.SqlServer.SmoExtended)

Answer the question

In order to leave comments, you need to log in

1 answer(s)
K
Konstantin Tsvetkov, 2017-11-04
@genek96

The working base itself is stuck in the recovery state. An attempt to output from it with the query "restore database [name_db] with recovery" ends with another error The database cannot be recovered because the log was not restored.
That is, you cannot complete a restore without a log.
Restore without it (NORECOVERY).

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question