Restore DB with afferent name

Posted on 2012-09-12
Last Modified: 2012-09-12
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.
Question by:minglelinch
    LVL 39

    Assisted Solution

    by:Kyle Abrahams
    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.
    LVL 12

    Accepted Solution

    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
    LVL 1

    Author Closing Comment

    Thanks a lot for the comments.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
    In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now