August 2, 2005 at 12:43 am
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
August 4, 2005 at 5:19 am
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
August 4, 2005 at 9:58 pm
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
August 5, 2005 at 9:42 am
An index is an object within a database. when changing is in one database it affects no others.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
August 9, 2005 at 1:25 am
which is what i thought, but why did both my dbs change ????
is it a refresh issue with EM????
------------------------------
Life is far too important to be taken seriously
August 9, 2005 at 9:17 am
EM does not 'auto refresh' so it may be another issue ...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply