Renaming logical file names

[pb648174]

Is there a way to rename the logical file names? I'm not talking
specifically about the physical files, because those can be changed
during a restore, but the values immediately to the left of those in
Enterprise Manager such as DBName_Data and DBName_log. Enterprise
Manager lets me change them during a restore, but when I do it gives an
error. Any ideas?

[Simon Hayes]

"pb648174" <go****@webpaul.net> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...

Is there a way to rename the logical file names? I'm not talking
specifically about the physical files, because those can be changed
during a restore, but the values immediately to the left of those in
Enterprise Manager such as DBName_Data and DBName_log. Enterprise
Manager lets me change them during a restore, but when I do it gives an
error. Any ideas?

ALTER DATABASE ... MODIFY FILE ...

See Books Online for the full syntax.

Simon