what does this output signify from sp_helpfile

I am confused as all get out.
new dba here.

I am using the command
exec sp_helpfile on all the db's in an instance


in column 1 (name) the name of the outputs from all the db's is the same name of this old database
and column 3 (filename) is actually pointing to the right files.

what could be causing the value returned in column 1 (name) from the command exec sp_helpfile
from different databases to have the same value from different databases?
jamesmetcalf74Asked:
Who is Participating?
 
Scott PletcherConnect With a Mentor Senior DBACommented:
The first column is the logical file name.  It's just an arbitrarily label for that file; for all SQL cares, it could be "zzz".

It's somewhat like table names.  They only have to be unique within the same db.  Same is true for logical file names.  As long as all the logical names are unique with a given db, SQL doesn't care if those same names are used for other dbs as well.  In theory, you could name the logical files in every db: 'a', 'b', 'c', etc..

Most people name it to have some relationship to the physical file name, in column 3, and that makes great sense logically and to help keep things in sync for us humans, but the computer doesn't require that.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.