June 10, 2008 at 12:42 pm
Hi.
I can rename database, I can rename physical name of a database file, but how to rename a logical name of a database file ?
Thanks
June 10, 2008 at 12:52 pm
From BOL:
To modify the logical name of a data file or log file, specify in NAME the logical file name to be renamed, and specify for NEWNAME the new logical name for the file.
Thus:
MODIFY FILE (NAME = logical_file_name, NEWNAME = new_logical_name...).
as part of alter database statement
---------------------------------------------------------------------
June 10, 2008 at 1:01 pm
Thanks, Goerge.
This is exacltly what I want. It worked perfevtly.
June 10, 2008 at 2:03 pm
no probs.
---------------------------------------------------------------------
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply