Learn how to a build a cloud-first strategyRegister Now


REstoring SQL Database sql 2005 Studio Management

Posted on 2009-12-22
Medium Priority
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
  • 2
  • 2
LVL 75

Accepted Solution

Aneesh Retnakaran earned 2000 total points
ID: 26108806
ask him to create another fullbackup and sent it over to you

Author Comment

by:Amanda Walshaw
ID: 26108833
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

ID: 26108847
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
ID: 26108973
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
ID: 31669225
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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Screencast - Getting to Know the Pipeline

810 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