Solved

what does this output signify from sp_helpfile

Posted on 2015-01-28
1
85 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
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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

813 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now