Restoring Database through .mdf file

how 2 restore database in MS SQL 2005 using .mdf & .ldf file

hi,

you can not "restore" a database via it's physical files, but you can attach a database pointing to your available physical files..

please have a look at the CREATE DATABASE .... FOR ATTACH syntax at http://msdn2.microsoft.com/en-us/library/ms187858.aspx

regards

|||You don′t need to restore from a MDF, you can simply attach the files using either the sp_attachdb commadn from TSQL or the option that comes up while rightclicking on the database node in SQL Server MS.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de