• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 103
  • Last Modified:

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?
1 Solution
Scott PletcherSenior 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.
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.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now