i am new to this field,i got an issue of restoring MDF files.
please tell me how to restore the MDF files.
thanks in advance
you just need to logon to the server where you want database to be included then use attach option and browse to path where you've mdf file. Make sure your server instance is of same version or above as the server from which mdf file was created.
As mentioned above you can't restore mdf file. You can attach it. A database can be attached by following methods: 1. SQL server management studio (SSMS) 2. Transact SQL (T-SQL) 3. sp_attach_db stored procedure.
I am also agree with jeffw8713 You can restore a database from a backup not MDF files. If You have corruption issue in your MDF Files then I can provide you an excellent SQL recovery software which can very easily repair your corrupted MDF Files, This effective application is Kernel for SQL Recovery Tool that repairs all kind of damaged MDF files of SQL Server database. You can also try it may be it help you.