How do you bring in a database to a SQL Server?

There are several ways you can bring in a database to a SQL Server:
Attaching the database data and data-log files to the server:

• By restoring a backup of the database
• By executing a script file
• Using the Import/Export tool
• etc..

After installing the SQL Server the first thing you may have to do is bring in some data. Microsoft has provided lots of samples and AdventureWorks is one such database of a hypothetical company and it is bigger than the Northwind database of another hypothetical company.