REstoring SQL Database sql 2005 Studio Management

Posted on 2009-12-22
Last Modified: 2012-05-08
I have created a database as instructed by software developer, just defaults nothing else.  he then gave me a database file to restore for the application.

When  I try and restore clicking on options finding the mdf and ldf path and restoring as file I am getting.

"Backup set holds a backup of a database other than the existing 'Mydatabase' database Restore Datatabse is terminating abnormally.
Question by:Amanda Walshaw
    LVL 75

    Accepted Solution

    ask him to create another fullbackup and sent it over to you

    Author Comment

    by:Amanda Walshaw
    this is the second one he has done but I will ask him again. I have checked options etc. and everything is okay.
    LVL 26

    Expert Comment

    may the script have an input parameter for specifying the database name for the user... if so and you didnt supply then it should produce an error
    LVL 75

    Expert Comment

    by:Aneesh Retnakaran
    backup database  to disk = 'C:\dbbackup.bak'

    that will create a backup, you need to ask him to run that query and sent  c:\dbBackup.bak to you

    Author Closing Comment

    by:Amanda Walshaw
    it was at the developer end, his instrutions were not clear, I had to restore the database not restore on an existinng database.

    once clarified all ok

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
    There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…

    761 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

    13 Experts available now in Live!

    Get 1:1 Help Now