I start off with an NDF file:-
07/01/2010 07:30 PM 65,404,928 sales_month199701.ndf
I use shrikfile to shrink it down:-
10/14/2010 08:08 PM 30,408,704 sales_month199701.ndf
I run a backup, and the size grows back again!
10/17/2010 06:51 PM 65,404,928 sales_month199701.ndf
Why? Will it make a difference if I set autogrowth off, and/or if I set the filegroup or file to read-only?
View Complete Post