I used to change the database name in the Enterprise Manager.
Because the Enterprise Manager cannot be directly modified, you can use a stupid method to back up the database and specify a new database name when restoring the database.
In addition, you cannot modify the logical file name when restoring data in the Enterprise Manager. Once the logical file name is modified, a prompt is displayed that you need to use restore filelistonly to RESTORE the data.
Therefore, the databases created later use the same logical file name.
After reading the online help today, you can use SQL scripts to get rid of it:
(Mk: @ MSITStore: C: \ Program % 20Files \ Microsoft % 20SQL % 20Server \ 80 \ Tools \ Books \ tsqlref. chm:/ts_aa-az_4e5h.htm)
-- Modify Database Name
Alter database shyq_data modify name = shyc_data
-- Modify the logical file name
Alter database shyc_data modify file (name = 'shyq _ data', newname = 'shyc _ data ')
Alter database shyc_data modify file (name = 'shyq _ log', newname = 'shyc _ log ')
It seems that you should take a closer look at the help in the future!