database name and logical name

#11

Many thanks.
Adrian.

"William (Bill) Vaughn" <billvaRemoveThis (AT) nwlink (DOT) com> wrote

Quote:

Ok, sorry for the confusion.
The "Logical Name" in this case is the filename header (before the .mdf
extension). Generally, the database name is the same as the logical name
as
"MyDatabase" is stored in "MyDatabase.MDF" and "MyDatabase.LDF" (log
file).
However, if you want to obfuscate the database name to protect or hide it,
you can set the logical name to another value. I do this sometimes when I
replace or upgrade databases.
In 99% of the cases you don't need to change the Logical Name--leave it to
match the Database Name.

hth

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no
rights.
__________________________________

"Adrian" <00 (AT) 00 (DOT) 00> wrote in message
news:44fbe55a$0$757$5fc3050 (AT) dreader2 (DOT) news.tiscali.nl...

"William (Bill) Vaughn" <billvaRemoveThis (AT) nwlink (DOT) com> wrote in message
news:uf9WWI6zGHA.1256 (AT) TK2MSFTNGP02 (DOT) phx.gbl...
The Logical_file_name is used when creating a database via attachment.
See
BOL "CREATE DATABASE (Transact SQL).

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/29ddac46-7a0f-4151-bd94-
75c1908c89f8.htm

Bill,

Your reference is to others with similar questions. That does not answer
my
query.
However, many thanks.

This is my question:

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.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

database name and logical name

Dotnet Framework (ADO.net) microsoft.public.dotnet.framework.adonet

Re: database name and logical name - 09-04-2006 , 02:25 PM