Logical file Names

martinb1000

Is it possible to retrieve the logical file names from a SqlBackup file ?

I am writing a generic restore program where a user selects a database they want restoring in a training system, and the process will restore from the selected sqlbackup from the live system

I need to specify the Logical_file_name in the MOVE command of the restore but this is dependent on what database is being restored. There is currently no set standard for the logical file name accross the servers and I dont want to hardcode the names...

petey

Use the RESTORE FILELISTONLY command e.g.

EXEC master..sqlbackup '-sql "RESTORE FILELISTONLY FROM DISK = [g:\backups\AdventureWorks.sqb] " '

martinb1000

Perfect - thanks