<div>
you want to restore a database with a .bak file <br />
<br />
Here is the step by step process with pictures on how to accomplish this :) <br />
<br />
<a href="http://social.technet.microsoft.com/wiki/contents/articles/7654.how-to-restore-a-database-backup-using-bak-file-in-ms-sql-server-2012.aspx" rel="ugc nofollow">http://social.technet.microsoft.com/wiki/contents/articles/7654.how-to-restore-a-database-backup-using-bak-file-in-ms-sql-server-2012.aspx</a>
</div>


you want to restore a database with a .bak file

Here is the step by step process with pictures on how to accomplish this :)

http://social.technet.microsoft.com/wiki/contents/articles/7654.how-to-restore-a-database-backup-using-bak-file-in-ms-sql-server-2012.aspx [http://social.technet.microsoft.com/wiki/contents/articles/7654.how-to-restore-a-database-backup-using-bak-file-in-ms-sql-server-2012.aspx]

<div>
It says, &quot;To create a new database, enter its name in the list box&quot;<br />
<br />
<br />
but its not letting me doe so
</div>


It says, "To create a new database, enter its name in the list box"


but its not letting me doe so

Screen.JPG

<div>
I tried to attach the .mdf file and i am getting an operating system error 5 - access is denied.
</div>


I tried to attach the .mdf file and i am getting an operating system error 5 - access is denied.

<div>
ah whatever group you are on in windows does not have full read/write control <br />
<br />
here's how you fix that :) <br />
<a href="https://filedb.experts-exchange.com/incoming/2014/05_w18/847904/Screen.JPG" target="_blank" title="Screenshot (60 KB)"><img alt="Screenshot" class="file-block lazyload" style="max-width: 446px;" data-src="https://filedb.experts-exchange.com/incoming/2014/05_w18/847904/Screen.JPG" /></a>
</div>


ah whatever group you are on in windows does not have full read/write control

here's how you fix that :)
Screenshothttps://filedb.experts-exchange.com/incoming/2014/05_w18/847904/Screen.JPG

<div>
Thank you for the very easy to follow instructions!
</div>


Thank you for the very easy to follow instructions!

<div>
<div class="content wysiwyg-content">
I have a .bak file for a database i want to use. &nbsp;How would i use it to create the database?<br />
<br />
Specifically, i downloaded: <br />
<br />
AdventureWorks2012-Full Database Backup.zip<br />
<br />
from here:<br />
<br />
<a href="http://msftdbprodsamples.codeplex.com/releases/view/55330" rel="ugc">http://msftdbprodsamples.codeplex.com/releases/view/55330</a>
</div>
</div>


I have a .bak file for a database i want to use.  How would i use it to create the database?

Specifically, i downloaded: 

AdventureWorks2012-Full Database Backup.zip

from here:

http://msftdbprodsamples.codeplex.com/releases/view/55330

.bak file to create database

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.

Microsoft SQL Server 2008

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.