MDF File Sizes -- sql server new users

Vayse
10/11/2006 12:00:00 AM

Hi
I have two databases set up, one for Office A and one for Office B. The
databases have the same structure.
There is a lot more data in the Office A database. Yet the Office B mdf is 6
times larger. Why would this be?
Thanks
Vayse

Keith Kratochvil
10/11/2006 9:20:02 AM

Possible reasons:
It was created with a larger initial size.
Someone ran dbcc shrinkfile on the database for Office A - or autoshrink is
enabled - and they did not shrink database B.

--
Keith Kratochvil

[quoted text, click to view]

sql server new users : MDF File Sizes