Restoring File Backups II

Sorry, I want restore only two files ( one filegroup) of
database ( not full backup). I don't have the transaction
log backups created since the file backups. I don't care
about changes. I want restore only files and (optional)
last log backup.Typically file backups can only be restored on the same database where they
were performed. If you want to restore them to a different database, then
starting point for such a restore has to be a complete backup. If you want
to restore these file/filegroup backups to a different database then follow
the steps below :
- Restore complete backup with standby
- Restore all file/filegroup backups with standby
- Use DTS or BCP to get the data out of the filegroups (since you cannot
bring the restore database online unless you apply all transaction log
backups)
Also, you cannot restore only the last log backup. If you need changes from
the last log, you WILL need all log backups from the latest filegroup
backup that you applied.
Thank you for using Microsoft newsgroups.
Sincerely
Pankaj Agarwal
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.