read from backup files

hi,
is there any SP or Tsql statment can read the logical
files name from backup files.
I know i can use RESTORE FILELISTONLY but i need to access
the files name and use them on a script.
regards,
AymanFrom what script do you want to access this information? Whatever you use,
you will have to make a connection to SQL Server, to run RESTORE
FILELISTONLY command.--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"ayman" <ayman.massri@.ihorizons.com> wrote in message
news:a1cf01c3ebfe$cb13d140$a101280a@.phx.gbl...
hi,
is there any SP or Tsql statment can read the logical
files name from backup files.
I know i can use RESTORE FILELISTONLY but i need to access
the files name and use them on a script.
regards,
Ayman|||hi,
I WANT TO CREATE A SCRIPT THAT RESTORE MY DB ONCE I HAVE A FAILURE
ACCOURDING TO MY BACKUP POLICY INSTEAD OF DOING THAT MANUALLY.
I need other way rather than RESTORE FILELISTONLY command.
regards,
Ayman
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!|||AFAIK, there are no other programs or commands that will read the header
info for a SQL Server backup. What is it that you don't like with RESTORE
HEADERONLY?
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"ayman masri" <ayman.massri@.ihorizons.com> wrote in message
news:ugsGAii7DHA.3360@.tk2msftngp13.phx.gbl...
> hi,
> I WANT TO CREATE A SCRIPT THAT RESTORE MY DB ONCE I HAVE A FAILURE
> ACCOURDING TO MY BACKUP POLICY INSTEAD OF DOING THAT MANUALLY.
> I need other way rather than RESTORE FILELISTONLY command.
>
> regards,
> Ayman
>
> *** Sent via Developersdex http://www.examnotes.net ***
> Don't just participate in USENET...get rewarded for it!