Home Forums SQL Server 7,2000 Administration Unable to shrink datafile RE: Unable to shrink datafile
anurag.shekhar
Mr or Mrs. 500
Points: 578
More actions
September 6, 2010 at 11:36 pm
#1217104
You are trying to release a huge amount of space at once. Try releasing it in smaller chunks. You can use the given script above. If it is not working try increasing the size of your datafile by few MBs and then use the script. It should work