What are the challenges you face when working across database platforms? Take the survey
Options

RESTORE FILELISTONLY?

MHolahanMHolahan Posts: 6
edited March 26, 2009 4:19PM in SQL Backup Previous Versions
I commonly copy Production data down to our Development and QA environments.

My file locations differ between these environments so I need to use the MOVE TO option of the RESTORE command. And I rely on the RESTORE FILELISTONLY command to ascertain the logical file name which is the argument that accompanies MOVE.

How do I get the logical file names of a SQL Backup backup?

Thanks,
Mark Holahan

Comments

  • Options
    Ah...I saw in an error message while executing the RESTORE DATABASE command that it's the same command, i.e. "RESTORE FILELISTONLY". And now on closer inspection, I've discovered that your documentation said so much all along.

    Thanks,
    Mark Holahan
Sign In or Register to comment.