How to Restore a Database on SQL Server Using .mdf, .ldf and .ndf Files
To restore a database on SQL Server using .mdf, .ldf, or .ndf files, rather than performing a restore, you will actually need to attach the database. There are two ways to do this. Using Enterprise Manager To attach a database using Enterprise Manager, follow these instructions: Expand the registered