Revcovery

Hi all,
I am trying to restore a database and get a 3234 error saying that the
logical file is not part of the database. I did a detach and reattach to the
database then a backup. Now I want to do a restore. Can anyone help. It does
say that I should use Restore Filelistonly. What does that mean and how do I
use it. Any help is appreciated.
Thanks
TomYou can determine the logical file names from the backup file using RESTORE
FILELISTONLY:
RESTORE FILELISTONLY
FROM DISK='C:\Backups\MyDatabase.bak'
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Tom" <tbrackney@.kc.rr.com> wrote in message
news:Mkl5d.63161$6h7.49180@.twister.rdc-kc.rr.com...
> Hi all,
> I am trying to restore a database and get a 3234 error saying that the
> logical file is not part of the database. I did a detach and reattach to
> the
> database then a backup. Now I want to do a restore. Can anyone help. It
> does
> say that I should use Restore Filelistonly. What does that mean and how do
> I
> use it. Any help is appreciated.
> Thanks
> Tom
>
>