• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 475
  • Last Modified:

restore database failed

I am trying to restore a back up into a new database that I just created. it gave me this message. Is there anything I am missing?

The backup set holds a backup of a database other than the existing (Restore failed
0
shpresa
Asked:
shpresa
  • 3
  • 3
1 Solution
 
QPRCommented:
try to do a restore filelistonly to see what the backup contains.
Also, can you show the syntax you are using to do the restore
0
 
shpresaAuthor Commented:
First I see two diffferent files in there..one is . trn and the other .bak

is there a difference?

what about the overwrite with replacement under options..do I need to check that?
0
 
QPRCommented:
The .bak is the full backup, the .trn is a backup of the transaction log.
You need to check overwrite the existing database.

What did you select initially, backup from database or backup from device?
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
shpresaAuthor Commented:
from device.
Thanks
0
 
QPRCommented:
Make sure overwrite existing is checked
0
 
shpresaAuthor Commented:
it worked just fine...thanks a lot for the help. appreciate it.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now