Microsoft SQL Server Management Studio Express

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.
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert Access -> SQL Server 2005 1
Unable to Attach Database 2
schema compare problem 4
about creating a database from Visual Studio 5
SQL Questions: Attaching Databases to SQL Server 4
installation of sql server management studio express 1
Stored Procedures Query 7
Stored procedures 4

Top