<div>
First run this command:<br />
RESTORE FILELISTONLY<br />
FROM MOVE 'logical_file_name_1' TO 'x:\full\path\to\data\file<wbr />\new_db_na<wbr />me.mdf',<br />
<br />
That will give you the list of logical file names you need to specify in the RESTORE command. &nbsp;Decide on a new path and file name for all of those files.<br />
<br />
Then complete and run this command:<br />
<br />
RESTORE DATABASE new_db_name<br />
FROM DISK = 'x:\full\path\to\backup\fi<wbr />le\theirdb<wbr />.bak'<br />
WITH --REPLACE, --only if overlaying an already existing db (not recommended, put allowed)<br />
MOVE 'logical_file_name_1' TO 'x:\full\path\to\data\file<wbr />\new_db_na<wbr />me.mdf',<br />
MOVE 'logical_file_name_2' TO 'x:\full\path\to\log\file\<wbr />new_db_nam<wbr />e_log.ldf'<wbr /><br />
--MOVE ...<br />
<br />
Btw, no, do <b>not</b> try to do this from the GUI, you will only cause yourself more problems and time.
</div>


<div>
First restore it to a *local* server: you have to create a new, empty database on your server, then in SSMS: right-click the new database -&gt; Tasks -&gt; Restore -&gt; Database -&gt; change to &quot;device&quot; to select your .bak file. The trick is that you have to have a blank database, first. Getting it up to Amazon is a whole process, but <a href="http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.Procedural.Importing.html" rel="ugc">here it is</a>.<br />

<blockquote>
If you have an existing Microsoft SQL Server deployment that you want to move to Amazon RDS, the complexity of your task depends on the size of your database and the types of database objects that you are transferring. For example, a database that contains data sets on the order of gigabytes, along with stored procedures and triggers, is going to be more complicated than a simple database with only a few megabytes of test data and no triggers or stored procedures.<br />
<br />
RDS for SQL Server service does not currently support RESTORE DATABASE ... FROM FILE, because the database and log file backups must be local to the SQL Server instance. Similarly, FILESTREAM is also not supported at this time.
</blockquote>
If you do not have a local server you'll need to install one - just download SQL 2014 Express edition or buy a $50(ish) copy of the developer version.
</div>


<div>
Where do enter these commands. Do I need to download a tool? Note, that the SQL instance is running on Amazon's RDS.
</div>


<div>
SSMS, Sql Server Management Studio. It's easiest to install an Express version of SQL Server &quot;with tools&quot;, which is SSMS:<br />
<a href="https://msdn.microsoft.com/en-us/sqlserver2014express.aspx" rel="ugc">https://msdn.microsoft.com<wbr />/en-us/sql<wbr />server2014<wbr />express.as<wbr />px</a>
</div>


<div>
Thanks all. <br />
<br />
The .BAK file is only 5MB. Because RDS does not currently support restore from a file, it appears that neither of above solutions will work for me using SSMS?
</div>


<div>
<div class="content wysiwyg-content">
One of our external developers sent us a copy of the SQL db so that we can upload it to our AWS sql server. He gave us a .bak file. How do I use this to attach the SQL db on my server?<br />
<br />
My end goal is to be able run queries against this database in our environment.
</div>
</div>


One of our external developers sent us a copy of the SQL db so that we can upload it to our AWS sql server. He gave us a .bak file. How do I use this to attach the SQL db on my server?

My end goal is to be able run queries against this database in our environment.

How to restore using a SQL .bak file

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.