Error when trying to recover a database.

Question

I have followed exactly the recovery procedure described at the msdn support page and I end up with this error when I try to recover.

http://img24.imageshack.us/img24/897/errorknd.jpg

I have tried several ways to do the backup as well but I end up with this error each time. But last time i tried it said 2 media families and not 3.

Answer 1

Frank,

Loos like you are backing up not one file but to multiple files. How are you backing up? with GUI or TSQL?

You can check this by looking at the RESTORE LABELONLY command. And search for the other backup file or try creating a new backup with only one file.

This link has some details and pictures to see.
http://riteshk.blogspot.com/2008/03/media-set-has-2-media-families-but-only.html

---

| Sankar Reddy | http://sankarreddy.spaces.live.com/ |

Answer 2

I used the graphic user interface in management studio, but I managed to pull it if now :)

The problem was that in the list over the locations I wanted to save the file I had multiple locations.. I removed all except one and tried a new full backup and it worked!

Thank you very much!