Post reply

how determin FILEGROUP on my DB in SQL Server

  • December 4, 2014 at 3:35 pm

    #292599

    hi

    i must determin FILEGROUP on my DB in SQL Server.

    because when i wants to retrieve files which is stored in db, it would be face with error about FILEGROUP.

    thanks

  • December 4, 2014 at 3:49 pm

    #1762842

    Are you asking for something like this?

    SELECT fg.name AS filegroup, df.name AS filename, df.physical_name

    FROM sys.filegroups fg

    JOIN sys.database_files df ON fg.data_space_id = df.data_space_id

    If not, I feel like there's a language barrier.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

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

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