救急.BAK文件在还到最后原时,提示一致性错误.请问有何办法可以读取数据?

显示全部楼层 · 2012-5-22 15:05:35

谢谢!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

千问 · 2012-5-22 15:05:35

是备份文件有损坏吗？

千问 · 2012-5-22 15:05:35

本帖最后由数据库探索者于 2012-3-8 09:22 编辑
备份文件有错误才会发生这个问题，修正BAK文件或者写个程序直接从BAK文件里提取出来

千问 · 2012-5-22 15:05:35

楼上2位好。是的。目前怀疑BAK文件有损坏

千问 · 2012-5-22 15:05:35

试试这个语句，可以检查到BAK文件是否损坏。
RESTORE VERIFYONLY
FROM [ ,...n ]
[ WITH
{
LOADHISTORY
--Restore Operation Option
| MOVE 'logical_file_name_in_backup' TO 'operating_system_file_name'

[ ,...n ]
--Backup Set Options
| FILE = { backup_set_file_number | @backup_set_file_number }
| PASSWORD = { password | @password_variable }
--Media Set Options
| MEDIANAME = { media_name | @media_name_variable }
| MEDIAPASSWORD = { mediapassword | @mediapassword_variable }
--Error Management Options
| { CHECKSUM | NO_CHECKSUM }
| { STOP_ON_ERROR | CONTINUE_AFTER_ERROR }
--Monitoring Options
| STATS [ = percentage ]
--Tape Options
| { REWIND | NOREWIND }
| { UNLOAD | NOUNLOAD }
} [ ,...n ]
]
[;]
::=
{
{ logical_backup_device_name |

@logical_backup_device_name_var }
| { DISK | TAPE } = { 'physical_backup_device_name' |

@physical_backup_device_name_var }
}

救急.BAK文件在还到最后原时,提示 一致性错误.请问有何办法可以读取数据?

救急.BAK文件在还到最后原时,提示一致性错误.请问有何办法可以读取数据?