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

Restore DB with afferent name

I would like to restore a database from db back up file .bak (not from .mdf .ldf files) on the same server with a fifferent database name. How can I can do it?  Thanks.
2 Solutions
Kyle AbrahamsSenior .Net DeveloperCommented:
Right click on databases -> restore database.

To Database = Target Name
from Device (find the bak file)

Under options, modify the MDF and LDF names to be the new database name.
If you are using sql server management studio, just right click and select restore database.

In the "To database" field, enter the new name.
Then under source for restore, select your .bak
minglelinchAuthor Commented:
Thanks a lot for the comments.
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

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

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