The process of restoring a database file, only MDF files, how to restore? In the original SQL Server 2005, click the database directly and then attach it can be restored, but in the 2008 version of the database file will be an error (only MDF file){Execute Transact-SQL statement or processing exception occurs} So now you can open the database of two files (mdf,ldf), right-click Properties,
Select Administrators (that is,the native user), modify the permissions to Full Control , as well as another file, and then follow the steps above to restore the database.
Another way is to copy the above two files directly to the default directory of the system database (C:\Program Files\Microsoft SQL Server\mssql10. Mssqlserver\mssql\data), using the SQL statement to restore. Reference steps:
Article source attached link
http://blog.csdn.net/yishengzhiai005/article/details/44944497
How to restore the. mdf data file in SQL Server 2008