logical and physical names ???

Question

logical and physical names ???

saurabh-655108

SSC Enthusiast

Points: 172
More actions
March 4, 2008 at 7:09 am

#179550

hi all,
🙂
I have started learning SQL server 2005 few days before so i come across some terms like logical and physical names of a database so i want to know what is the meaning of logical and physical names of a database or a file ?????????
In what contest these terms are used ?????
Thanx

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

pmohan SSC Eights! Points: 941 More actions · Answer 1

Physical name of a database is the path along with the name of the file you give to store the database in that path eg:(c:\pubs.mdf). Logical name is the name you give for this (eg: c:\pubs.mdf can be called as pubs).

saurabh-655108 SSC Enthusiast Points: 172 More actions · Answer 2

hi,

thanx 4 the reply

can u tell me how to give a logical name to a physical name and how it is useful ??

thanx again

pmohan SSC Eights! Points: 941 More actions · Answer 3

For example when you are creating a database,

CREATE DATABASE Sales

ON

( NAME = Sales_dat,

FILENAME = 'c:\mssql7\data\saledat.mdf',

SIZE = 10,

MAXSIZE = 50,

FILEGROWTH = 5 )

In the above example, the name is logical name and file name is physical name.