Why do you need a logical database name in MS SQL Server?

Question

Database administration

Hello.
Why is the logical name of the MS SQL Server database needed?
There is a database name that we refer to in the query: select * FROM myDB.dbo.myTable,
but the "myDB" database has a completely different logical name.
Can I change the logical names of the combat database to "hot"?

Answer 1

There are no logical names, only .select name from sys.databases

In the recovery script, you need to prescribe the logical name of the database, which is stored in the file.

sys.database_files .

I transfer the database to offline mode and execute the script for renaming.

Moving user databases .