Post reply

A Database with no files...

  • December 12, 2013 at 9:32 am

    #281200

    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?

  • December 12, 2013 at 9:45 am

    #1673010

    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

  • December 13, 2013 at 1:45 am

    #1673180

    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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply