If you mean that you want to be able to attach the database on another server, then this is what you can do: detach the database (right click the database and click Detach) copy the mdf and ldf files to your backup location attach the database (right click Databases and click Attach) This is the … Read more
Open SQL Management Studio Express and log in to the server to which you want to attach the database. In the ‘Object Explorer’ window, right-click on the ‘Databases’ folder and select ‘Attach…’ The ‘Attach Databases’ window will open; inside that window click ‘Add…’ and then navigate to your .MDF file and click ‘OK’. Click ‘OK’ … Read more
SQL Server databases use two files – an MDF file, known as the primary database file, which contains the schema and data, and a LDF file, which contains the logs. See wikipedia. A database may also use secondary database file, which normally uses a .ndf extension. As John S. indicates, these file extensions are purely … Read more