RESTORE FILELISTONLY?

MHolahan

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,

MHolahan

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,