SQL Server 2005 Restore to Different Database Issue

Posted on 2009-02-18
Last Modified: 2012-05-06
Hi, I have a database backup that I am trying to restore to another database on the same server (different name). I keep getting the the error below...

Is there a way to restore a database to a different database with different name? I went to options and selected "Overwrite the existing database" but the restore options seem wrong (wrong names).
What am I doing wrong?

TITLE: Microsoft SQL Server Management Studio

Restore failed for Server xxxxxxxxxx. (Microsoft.SqlServer.Smo)

For help, click:


System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing 'xxx_DEV_V1' database. (Microsoft.SqlServer.Smo)
Question by:ChiBella
    1 Comment
    LVL 24

    Accepted Solution

    I believe this is telling you that you have multiple database backups in this set or that the existing one that you tried to overwrite is not the same database as the backup is.

    You need to verify what you have in the backup set.  I would do a

    and see what is in the backup set.  Also, you do not need to use the Overwrite option if the database does not exist yet.

    I gather that you want to keep the current database and restore the database backup to a new database name.  You must move the files to a new location because it will want to restore the files to the same location as they were backed up from.  You cannot do this because there is already an active database existing with those files.

    If you are comfortable with TSQL and restore then use
    RESTORE DATABASE newname FROM DISK='path to file'
    WITH MOVE 'first file logical name' TO 'new path for this file',
              MOVE 'second file logical name' TO 'new path for this file'

    and if the database exists (newname) then use the ", REPLACE" after the last statement above.  

    If you want to use SSMS then you will want to Right click on Databases and choose Tasks, Restore Database, then type in the database name that you want to restore to and choose from Device.
    Click Add and get to your file.  Then you should see a list of database backups in the box below where you chose the file.  You have to choose one of the checkboxes to restore which database backup.  Make sure that the name in the Database Name is your 'newname' of your database.
    Then you will need to go to the Options tab and look at the files listing, and then go to the paths of the files and change them to be what they should be to be in a new place and have a new name that does not conflict with already existing databases.

    That is a lot, let me know if you have any questions or need more information on this.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
    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 seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    731 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