Post reply

help with files in database

  • December 1, 2014 at 3:49 am

    #312814

    Hi

    We have 153 gb database consisting 3 primary and 1 log files.

    while 1 primary file and 1 ndf files resides on same disk while other ndf file resides on another drive while lof file resides on other file

    Isue is that mdf file size is around 150 gb size while those other ndf file size is in mb`s ...

    Isuse is that i am running out of space on in drive in which mdf files resides ...

    I just wanted to know why in`t size of those ndf file increasing , it looks like sql server isadding all data in mdf file itself

    Second if i restrict mdf file size to particular size , will i see increase in size of both ndf files or i can face some error like no sapce in filegroup ????

    Rregards

    Anoop

  • December 1, 2014 at 4:12 am

    #1761642

    Are the files all in the same filegroup? Or are they in three different filegroups?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • December 1, 2014 at 4:17 am

    #1761644

    GilaMonster (12/1/2014)

    Are the files all in the same filegroup? Or are they in three different filegroups?

    Same filegroup --> primary

  • December 1, 2014 at 4:27 am

    #1761648

    Please will you post the result of this query?

    John

    SELECT type_desc, data_space_id, name, size, max_size, growth

    FROM MyDB.sys.database_files

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

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