还是不行,高手请帮忙!!!
昨天我的数据库日志*.ldf文件误删除后,我用工具将回收站的东西恢复,但有一个数据文件总报错,是什么意思?
无法让我再做下去,请问有什么办法可忽略这个数据文件吗?谢谢!
如下:
操作:
CREATE DATABASE bpcs_prod
ON PRIMARY (FILENAME = 'd:\bpcsdbbk\bpcs_prod_data.MDF')
FOR ATTACH
GO
结果:
Server: Msg 5172, Level 16, State 15, Line 1
The header for file 'F:\bpcs_data\bpcs_prod_data3' is not a valid database file header. The PageAudit property is incorrect.
Server: Msg 5105, Level 16, State 1, Line 1
Device activation error. The physical file name 'F:\bpcs_data\bpcs_prod_data3' may be incorrect.
Server: Msg 1813, Level 16, State 1, Line 1
Could not open new database 'bpcs_prod'. CREATE DATABASE is aborted.