470,648 Members | 1,607 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,648 developers. It's quick & easy.

Renaming logical file names

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?

Jul 23 '05 #1
1 2714

"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
Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by hokiegal99 | last post: by
reply views Thread by MikeY | last post: by
16 posts views Thread by dudufigueiredo | last post: by
1 post views Thread by Don Leverton | last post: by
1 post views Thread by MikeY | last post: by
1 post views Thread by boops boops | last post: by
6 posts views Thread by Rob | last post: by
8 posts views Thread by BillCo | last post: by
1 post views Thread by Korara | last post: by
reply views Thread by warner | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.