Data/Transaction log files for two databases have same file name

We have two db's. One live and one test.

When I right click on the live one in SQL Enterprise Manager and
select properties -> Data Files ->
File Name is LIVE.MDF
Location is F:\Data\LIVE.MDF

When I right click on the test one in SQL Enterprise Manager and
select properties -> Data Files ->
File Name is LIVE.MDF
Location is F:\Data\TEST.MDF

Same thing applies to Transaction log files too.

My concern is File Name is same in both the above cases even though
the location is different. What are the consequences of this.

Thanks for your help

GVVGirish (kattukuyil@.hotmail.com) writes:
> When I right click on the live one in SQL Enterprise Manager and
> select properties -> Data Files ->
> File Name is LIVE.MDF
> Location is F:\Data\LIVE.MDF
> When I right click on the test one in SQL Enterprise Manager and
> select properties -> Data Files ->
> File Name is LIVE.MDF
> Location is F:\Data\TEST.MDF
> Same thing applies to Transaction log files too.
> My concern is File Name is same in both the above cases even though
> the location is different. What are the consequences of this.

Nothing. The filename in question is just a logical name within the
database.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp