При полном резервном копирование произошла
ошибка2017-12-17 01:16:05.41 Backup Database backed up. Database: backup, creation date(time): 2017/11/25(18:29:57), pages dumped: 82855714, first LSN: 490877:92888:1, last LSN: 490882:64941:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'\\path\to\file\backup\backup_2017_12_17_004006_4520295.bak'}). This is an informational message only. No user action is required.
2017-12-17 01:16:05.45 Backup BACKUP DATABASE successfully processed 82855561 pages in 2138.317 seconds (302.718 MB/sec).
2017-12-17 01:16:05.56 spid89 Ошибка: 3266, серьезность: 16, состояние: 1.
2017-12-17 01:16:05.56 spid89 The backup data at the end of "\\path\to\file\backup\backup_2017_12_17_004006_4520295.bak" is incorrectly formatted. Backup sets on the media might be damaged and unusable. To determine the backup sets on the media, use RESTORE HEADERONLY. To determine the usability of the backup sets, run RESTORE VERIFYONLY. If all of the backup sets are incomplete, reformat the media using BACKUP WITH FORMAT, which destroys all the backup sets.
2017-12-17 01:37:50.75 Backup Ошибка: 18210, серьезность: 16, состояние: 1.
2017-12-17 01:37:50.75 Backup BackupIoRequest::ReportIoError: read failure on backup device '\\path\to\file\backup\backup_2017_12_17_004006_4520295.bak'. Operating system error 13(Недопустимые данные.).
при попытке восстановить данный бекап. также возникает
ошибка2017-12-27 22:48:10.93 spid55 Ошибка: 3266, серьезность: 16, состояние: 1.
2017-12-27 22:48:10.93 spid55 The backup data at the end of "D:\backup_2017_12_17_004006_4520295.bak" is incorrectly formatted. Backup sets on the media might be damaged and unusable. To determine the backup sets on the media, use RESTORE HEADERONLY. To determine the usability of the backup sets, run RESTORE VERIFYONLY. If all of the backup sets are incomplete, reformat the media using BACKUP WITH FORMAT, which destroys all the backup sets.
2017-12-27 23:04:52.38 Backup Ошибка: 18210, серьезность: 16, состояние: 1.
2017-12-27 23:04:52.38 Backup BackupIoRequest::ReportIoError: read failure on backup device 'D:\backup_2017_12_17_004006_4520295.bak'. Operating system error 13(Недопустимые данные.).
пробовал выполнять так:
RESTORE DATABASE [test_backup] FILE = N'backup' FROM DISK = N'D:\backup_2017_12_17_004006_4520295.avi' WITH FILE = 1,
MOVE N'backup' TO N'G:\DATA\test_backup.mdf',
MOVE N'backup_log' TO N'G:\DATA\backup_log.LDF',
RECOVERY, NOUNLOAD, STATS = 10, CONTINUE_AFTER_ERROR
GO
ошибка: Сообщение 3013, уровень 16, состояние 1, строка 1
RESTORE DATABASE прервано с ошибкой.SQLServer2016 Standart 13.0.4001.0
Подскажите есть ли способ его восстановить?
Простой
