I have a db with a mdf and ldf. And the mdf file size is around 350 gba and nearly 60% of its having free space and occupied the complete drive. Someone from our team had modified the filegrowth parameters from standard set by us. Now we had started the shrinking of mdf file from gui. Shrink process is running for the past 18 hours and its completed only 60%. If I kill the shrink process now will it have any impact on my database. Please resond asap.
asked May 06, 2010 at 05:26 AM in Default
Yes, it's safe to kill it.
But why would you want to shrink it anyway? There's certainly no problem in having lots of free space in your data file.
answered May 06, 2010 at 05:30 AM
Matt Whitfield ♦♦