Logical file Names
martinb1000
Posts: 8
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...
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...
Comments
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8