Microsoft SQL Server Management Studio Express

  • Thread starter Thread starter Adrian
  • Start date Start date
A

Adrian

In Microsoft SQL Server Management Studio Express
If one clicks on "Databases"
One can select "New Database"
There "Database Name"
and "Logical Name" has to be entered.

Could you please tell me what the difference
between these two terms is?

Adrian.
 
Adrian,

In this context the logical name is the name of the .mdf file that will be
used to hold the database.

That name does not have to match the database name, but the default is to
use the database name with a ".mdf" extension.

Also notice that you can specify multiple logical files to hold the
database, but again the default is to have one logical file.

Kerry Moorman
 
Back
Top