Solved

what does this output signify from sp_helpfile

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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Database Integrity 1 50
SSMS Opening Mode 9 20
Update one table with results from another table in SQL 6 27
SQL Recursion schedule 13 16
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
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.

829 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