restoring sql database from backup

Posted on 2011-10-12
Last Modified: 2012-05-12
I have sql 2005 and im using microsoft sql server managment studio on a windows 2008 server.

i have done test restores before where i restored backups to a different database name.
this time i have to restore foreal.....

so for instance.
i have to restore the current database "medical" back to a week from today. but i need to restore it as medical.
do i delete the current medical or rename it.  then restore the back up to medical.
whats the best way to restore a current in use database?

delete or rename active database or something different?
Question by:jamesmetcalf74
    LVL 28

    Accepted Solution

    You have several options, but assuming that you just want to replace the existing database, you go through the restore wizard and select the option to "Overwrite Existing Database"

    More info:
    LVL 12

    Assisted Solution

    For sure if you do not need the current database, you could delete it first, then perform a restore.
    Optionally, (in case you do not want to delete the database first) you can restore with the option (overwrite existing database) in SQL server management studio.

    Either way, the choice is yours :-)

    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.

    Suggested Solutions

    In this article—a derivative of my blog post (—I will explore a few different perspectives on which week today's date falls within using Microsoft SQL Server. First, to frame this stu…
    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
    Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

    737 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

    18 Experts available now in Live!

    Get 1:1 Help Now