When we're using SQL Server, we can use several different methods to transfer data into our SQL Server instance. Two very fast and straightforward options use backup, and the attach and detach option for SQL Server. If we're given a backup of a database, we can restore the backup to our SQL Server to get access to all tables and other objects that are stored in the database. Such a backup would usually be provided as one single file (the file extension really doesn't matter, but it's common to use .bak), which you can copy to your server and use either the SQL Server Management Studio or T-SQL code to restore the database in your environment:
USE [master]GORESTORE DATABASE [DemoDB] FROM DISK = 'c:\SQLData\DemoDB.bak' ...
