How do I resize DB files

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

B - 30 Sep 2008 15:05 GMT

Hi and thanks in advance for any replies. I have a database made up of 6
files (Mdf & Ndf). I unfortunately allowed the main MDF file to expand and
didn't allow the other 5 files to autogrow. I now have a huge MDF file. Is
there a way I can resize the database to redistribute the data across all my
files to even out the file sizes?

Reply to this Message

Tibor Karaszi - 30 Sep 2008 15:09 GMT

Shrink the (mdf) file down to how much data you want in there. That will "push" pages over to the
other files (for that filegroup). You can then expend the file back to a reasonable size. See DBCC
SHRINKFILE.

Signature

Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

> Hi and thanks in advance for any replies. I have a database made up of 6
> files (Mdf & Ndf). I unfortunately allowed the main MDF file to expand and
> didn't allow the other 5 files to autogrow. I now have a huge MDF file. Is
> there a way I can resize the database to redistribute the data across all my
> files to even out the file sizes?

Reply to this Message