Post reply

Database Data Files out of Sync

  • July 21, 2014 at 11:43 am

    #293678

    I've stepped into a new environment and have never dealt with multiple data files on user databases only with Temp db.

    What would be the best way to get all my data files in sync. I have done this on databases that aren't that big in size or off in size by a lot. But not like this, Is there an easy way to do this or a best practice that some one could help me with?

    Here is what I have

    Mdf -- 69 GB

    ndf -- 3

    ndf -- 3

    ndf -- 3

    ndf -- 3

    ndf -- 4

    ndf --4

    ndf -- 2

    SQL Server 2012

    Thanks in advance

  • July 21, 2014 at 12:14 pm

    #1731145

    What do you mean by 'in sync'?

    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

  • July 21, 2014 at 12:27 pm

    #1731162

    On the guess that you mean you want all of the files to be the same size, or the same usage, this may go one of two ways. Are all of these files in the same filegroup, or are there multiple filegroups?

  • July 21, 2014 at 12:34 pm

    #1731165

    Yes the same size and yes there all in the same file group.

    Thank you

  • July 21, 2014 at 1:09 pm

    #1731182

    I got this handled now

    Thanks everyone

  • July 21, 2014 at 1:12 pm

    #1731183

    How did you handle this? I had no experience and therefore no input, but I was watching the thread so I could learn what needed to be done.

  • July 22, 2014 at 8:32 am

    #1731446

    I shrunk the file to get the space that wasn't being used released. then allocated the size I needed across the other 7 files.

    Thanks

  • August 4, 2014 at 8:22 am

    #1734862

    I am having the exact same problem but not able to fix it. Can you give more detail on how you fixed this?

Viewing 8 posts - 1 through 7 (of 7 total)

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