How to Move MSSQL to a New Server

One way to manually move an entire MSSQL database to a new server is to copy the database files: the .mdf (Main Data File) and the .ldf (Transaction Log File). What are .mdf and .ldf files? The .mdf file contains all the data and structure of the dat...