Logical filename and physical filename issue / question

Question

Post reply

Logical filename and physical filename issue / question

adamcrv

Hall of Fame

Points: 3056
More actions
August 2, 2005 at 12:43 am

#90465

Hi,

I have 3 dbs, 2 are full restores of the original one,

the logical flenames are the same for all three as well as log files, eg

database1_data

database1_data

database1_data

but the physical names are different as well as logs

db1_data.mdf

db2_data.mdf

db3_data.mdf

however when i make a change in the relationship area, eg tick the box enforce relationship for existing data, the data errors the relationship and the key is dropped...

however this key in enterprise manager disappears from all three.

is this issue because the logical names are the same ? i havent test this as im not sure how to change a logical file name...dont think you can when restoring from a backup..

thanks any help you can provide people...

Adam

------------------------------
Life is far too important to be taken seriously

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

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

N J Right there with Babe Points: 732 More actions · Answer 1

N J

Right there with Babe

Points: 732

August 4, 2005 at 5:19 am

#579501

Adam,

You can modify the logical file name of the database using alter database command even after restoring from the backup.

ALTER DATABASE 'DB Name'

MODIFY FILE(NAME = logical_file_name, NEWNAME = new_logical_file_name)

GO

adamcrv Hall of Fame Points: 3056 More actions · Answer 2

adamcrv

Hall of Fame

Points: 3056

August 4, 2005 at 9:58 pm

#579900

Thanks !

Thats good to know...but..what about my other issue, does changing an index in one db with the same logical name as another change it in both..should it ?..is it by design or a SQL server issue??

------------------------------
Life is far too important to be taken seriously