• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 318
  • Last Modified:

create a database from sql backup.bak

I want to do this using sql server 2005 enterprise
1 Solution
In SSMS, right click 'databases', select 'restore database'.  Enter your new database name, choose 'from device' then input the full path to your bak file.  Click ok and your restore will create the new database.  

If you want to control the location of the mdf and ldf files, you will have to select the 'options' page and modify the paths there.  

After the restore completes you will have to create your logins and map those to the existing (de-orphan) or create new users in your database.  

rgb192Author Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now