Is there a way to rename the logical database file names during the database restore process? I know that I can do it after the database restore using the following command:
ALTER DATABASE your_new_database
MODIFIY FILE ( NAME = [current_logical_name], NEWNAME = [new_logical_name] )
However, I don't see anything in the "RESTORE DATABASE" syntax that allows you to do that. Does this exist, or does it need to be done after the database restore?