我无法附加mdf文件，因为它不是主文件
问题描述：
亲爱的所有
我有SQL Server 2008 R2版本数据库的mdf文件，有些我的客户端没有以正确的方式分离数据库所以我损坏了mdf文件。现在我无法附加它因为它给我的错误mdf和日志文件不是主要的
请指导我如何使用mdf文件恢复数据
问候
Dear All
I have mdf file of SQL sever 2008 R2 version database, some how my client has not detach the database in right way so i have corrupted mdf file. now i am unable to attach it as it is giving me the error that mdf and log files are not primary
please guide me how to restore the data using the mdf file
regards
答
检查你试图附加的数据库是否是相同的版本，万一
如果你使用的是Sql Server 2008则不能直接附加在这种情况下你需要安装一些支持这个R2数据库的实用工具。
问候，
Gunaprasad
Hi,
Check the database you are trying to attach is of the same version or not, in case
if you are using Sql Server 2008 then its not possible directly to attach the copy of R2 database in that case you need to install some utilities which support this R2 database.
Regards,
Gunaprasad