File numbers in backup files

When i backup, everyday, A db to the same file(using noinit option), how can
I know the nmber of each file in order to be able to restore the the one I
want using with file = 1 or 5 or 6. Is there a sp or a sus table
Thanks
RESTORE HEADERONLY
Also see the backup history tables in the msdb database.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"SalamElias" <eliassal@.online.nospam> wrote in message
news:00E117EF-9023-444D-8B3A-2DC8FB4F2F4B@.microsoft.com...
> When i backup, everyday, A db to the same file(using noinit option), how can
> I know the nmber of each file in order to be able to restore the the one I
> want using with file = 1 or 5 or 6. Is there a sp or a sus table
> Thanks
|||Hi,
This is Charles from Microsoft Online Community Support. I'm responsible
for checking the issue status.
Please feel free to let us know if you need further research. It's always
our pleasure to be of assistance.
Charles Wang
Microsoft Online Community Support