Dont know, maybe this is a small question..
I have scenario like DBallocated size 10GB, free available size 7GB, used space is 3GB, for datafile file id 1
I start shrink operation on Datafile ..
dbcc shrinkfile(1,9950) dbcc shrinkfile(1,9900) ----- ------- dbcc shrinkfile(1,3400)
like this I have created job, but after some time, the used space is 4GB, free space is 5.100GB
If it continues, at end of the shrink command, what will happen?
please any one can understand my problem give me correct input