Logical names of the databases

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tshad - 13 Nov 2008 23:27 GMT

I know how to get the logical name of a database from the backups (RESTORE
FILELISTONLY), but how do I get it from the database itself?

Thanks,

Tom

Reply to this Message

Tom Moreau - 13 Nov 2008 23:39 GMT

Could you be more specific? Would the following work:

select
db_name()

Signature

Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau

I know how to get the logical name of a database from the backups (RESTORE
FILELISTONLY), but how do I get it from the database itself?

Thanks,

Tom

Reply to this Message

Dan Guzman - 14 Nov 2008 02:14 GMT

Do you mean list the logical file names of an existing database? In that
case, try sp_helpdb:

EXEC sp_helpdb 'MyDatabase'

Signature

Hope this helps.

Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/

>I know how to get the logical name of a database from the backups (RESTORE
>FILELISTONLY), but how do I get it from the database itself?
>
> Thanks,
>
> Tom

Reply to this Message

tshad - 17 Nov 2008 21:27 GMT

> Do you mean list the logical file names of an existing database? In that
> case, try sp_helpdb:
>
> EXEC sp_helpdb 'MyDatabase'

That was it.

I just wanted to be able to find the Logical name so I could use that to
change the logical name to match the DB name when I use a different Backup
to restore the database.

It seems to be in the second set of data that comes back where I assume the
name = Logical name and the filename is the actual db files.

Thanks,

Tom

>>I know how to get the logical name of a database from the backups (RESTORE
>>FILELISTONLY), but how do I get it from the database itself?
>>
>> Thanks,
>>
>> Tom

Reply to this Message

Dan Guzman - 18 Nov 2008 12:31 GMT

> It seems to be in the second set of data that comes back where I assume
> the name = Logical name and the filename is the actual db files.

If you don't the other information, one method to list only the files is
sp_helpfile:

USE MyDatabase
EXEC sp_helpfile

You can also get this information with SELECT * FROM sys.database_files.

Signature

Hope this helps.

Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/

>> Do you mean list the logical file names of an existing database? In that
>> case, try sp_helpdb:
[quoted text clipped - 20 lines]
>>>
>>> Tom

Reply to this Message

tshad - 20 Nov 2008 00:23 GMT

>> It seems to be in the second set of data that comes back where I assume
>> the name = Logical name and the filename is the actual db files.
[quoted text clipped - 6 lines]
>
> You can also get this information with SELECT * FROM sys.database_files.

I'll look at those as well.

Thanks,

Tom

>>> Do you mean list the logical file names of an existing database? In
>>> that case, try sp_helpdb:
[quoted text clipped - 20 lines]
>>>>
>>>> Tom

Reply to this Message