Large mdf

Question

Large mdf

SqlScared

Ten Centuries

Points: 1000
More actions
October 29, 2014 at 7:53 am

#397579

I have a production db with 3 file groups, mdf is approaching 1TB and I don't want it to grow beyond that. Can I just restrict file growth on the mdf and let the ndf files grow? This is a vendor db that I inherited and it was not sized properly from the beginning. Thanks

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

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

If you have three data files in three separate filegroups, no you can't. If you restrict growth on the mdf and it's the only file in the PRIMARY filegroup, when it fills up you'll start getting errors.

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

spaghettidba SSC Guru Points: 105732 More actions · Answer 2

Yes, that will work, assuming those ndfs are in the same filegroup as the mdf.

-- Gianluca Sartori

SqlScared Ten Centuries Points: 1000 More actions · Answer 3

Thank you Gail and Gianluca. The data files are in separate filegroups so I'm out of luck.

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 4

SqlScared (10/29/2014)
Thank you Gail and Gianluca. The data files are in separate filegroups so I'm out of luck.

Maybe not. Transfer some of the tables to the other file groups.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)