Logical File Name

Question

Logical File Name

gedeon

SSC Veteran

Points: 262
More actions
January 8, 2003 at 7:34 am

#58661

Hi,
Is it possible via the ALTER DATABASE command, to rename the logical file name of a specific database (and not the os file name) ?
Best regards,
Michael.

Best regards,

Michael.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Allen Cui-55137 SSC Guru Points: 51650 More actions · Answer 1

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...).

in ALTER DATABASE command.

Gabor Nyul SSCrazy Eights Points: 9459 More actions · Answer 2

Have a look in the BOL

The syntax is:

alter database YourDB modify file (name = OldLogicalName, Newname = NewLogicalName)

Bye
Gabor

gedeon SSC Veteran Points: 262 More actions · Answer 3

Could we used this command in SQL7 SP3 ?

When I try it, I receive =>

'newname' is not a recognized CREATE/ALTER DATABASE option.

Best regards,

Michael.

zach_john SSCertifiable Points: 5922 More actions · Answer 4

ALTER DATABASE MODIFY FILE (NAME = logical_file_name, NEWNAME = new_logical_name...). is a SQL 2K thing, not sure of how to do that in 7

John Zacharkan