Hey chaps,
I have following situation:
- SQL Server 2008 database, in full recovery model
- I created a full backup, and an hour later a transaction log backup (both to separate files, so I have a .bak file, and a .trn file)
Now for testing purposes, I want to restore the database using these two files. I am doing this on the same server as from where the backup was taken.
- So in Management Studio, I right click the DB, select Tasks, Restore, Database
- Instead of restoring "From Database", I want to test the case that I need to restore to a new server which doesn't have the backup history, so I select "From Device".
- I then add the two files (the .bak and the .trn) in the "Specify backup" dialog.
- But when I click OK, I get following error:
The media loaded on 'D:(mybackupfilename).bak' is formatted to support 1 media families, but 2 media families are expected according to the backup device specification. RESTORE HEADERONLY is terminating abnormally (Microsoft SQL Server, Error: 3231)
So it doesn't even allows me to see the headerinfo of the backup files.
If I select and restore the two files one by one, it works. But I would expect to have the possibility to select both files at once and decide from there one which ones I need to restore (and possibly specifying the "point-in-time").
I googled along but cannot seem to find an answer to this.
Am I doing something wrong or is this a bug (which a colleague of mine seems to suggest).
Thx for any replies
TJ