Solved

what does this output signify from sp_helpfile

Posted on 2015-01-28
1
90 Views
Last Modified: 2015-02-02
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?
0
Comment
Question by:jamesmetcalf74
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 69

Accepted Solution

by:
Scott Pletcher earned 500 total points
ID: 40576282
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

Featured Post

Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

717 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question