.bak file to create database

vbnetcoder
vbnetcoder used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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

Author

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


but its not letting me doe so
make sure you have all the files and the location they are in
you want the .mdf

download the first file
http://msftdbprodsamples.codeplex.com/releases/view/93587


here is an even better example video
https://www.youtube.com/watch?v=tILCng28a1k
Screen.JPG
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
I tried to attach the .mdf file and i am getting an operating system error 5 - access is denied.
ah whatever group you are on in windows does not have full read/write control

here's how you fix that :)
Screenshot

Author

Commented:
Perfect! Thanks!

Author

Commented:
Thank you for the very easy to follow instructions!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial