Restoring database problem

While restoring backup from ad.bak file to already existing database followi
ng error is appeared "Cannot find file Id 2 on device C:\dbBackup\ad.bak ba
ckup or restore operation terminated abnormally " This is happened when i tr
y to restore database.Hi
Can you show us your RESTORE command?
"nadeem" <anonymous@.discussions.microsoft.com> wrote in message
news:CE62DBDE-C168-49B1-BB42-F89B1881A438@.microsoft.com...
> While restoring backup from ad.bak file to already existing database
following error is appeared "Cannot find file Id 2 on device
C:\dbBackup\ad.bak backup or restore operation terminated abnormally " This
is happened when i try to restore database.|||Hi,
You can use the RESTORE HEADERONLY command to idenfify the backup file list
and use RESTORE DATABASE to restore the specific file.
Sample code
RESTORE HEADERONLY FROM DISK='c:\backup\dbname.bak'
RESTORE DATABASE mydatabase FROM DISK='C:\backup\dbname.bak' WITH FILE =
FileNumber
(Use option MOVE if you have the database already in the same server)
Thanks
Hari
MCDBA
"nadeem" <anonymous@.discussions.microsoft.com> wrote in message
news:CE62DBDE-C168-49B1-BB42-F89B1881A438@.microsoft.com...
> While restoring backup from ad.bak file to already existing database
following error is appeared "Cannot find file Id 2 on device
C:\dbBackup\ad.bak backup or restore operation terminated abnormally " This
is happened when i try to restore database.