Import Data to SQL Server

1. On the existing server
Go to Microsoft SQL Server Studio Express
Task > Backup >
* take note to create the backup to only a single media file, unless you have to split it up.

2. On the new server
Go to Microsoft SQL Server Studio Express
Task > Restore
* there is no need to create a new database with the same name if this is a completely new restore. once we set the database file device, the new database name will appear to be restored.