Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

A Database with no files... Expand / Collapse
Author
Message
Posted Thursday, December 12, 2013 9:32 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, December 12, 2013 9:56 AM
Points: 16, Visits: 25
So here's an odd one, just been looking at a SQL server, when looking at the database properties via SQL Server Management Studio, the databases seem to have no "files", the properties page doesn't show any; yet when executing sp_helpfile on the same databases, files are returned.

Anyone seen this before?

Post #1522378
Posted Thursday, December 12, 2013 9:45 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 8:58 AM
Points: 5,077, Visits: 8,918
No, I haven't. But you could run a trace to see what SQL is being fired when you bring up the Properties page, and hence why it isn't showing anything.

John
Post #1522383
Posted Friday, December 13, 2013 1:44 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, March 20, 2014 4:03 AM
Points: 1,396, Visits: 549
You could check using:

USE [master]
GO

SELECT *
FROM sys.master_files;

That will list all the files for all the DBs on the instance.


Regards,

Phil
Post #1522599
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse