Tag Info

New answers tagged

0

This quote below is directly from Microsoft (applies to versions 2008-2016), and gives guidance on if/when and how you should use the DBCC SHRINKFILE command. https://msdn.microsoft.com/en-us/library/ms189493.aspx Best Practices Consider the following information when you plan to shrink a file: A shrink operation is most effective after an ...


0

Actually I had to replace the log file to another drive which has space. Then I was able to delete the things and shrink until I freed space in DATA drive.


2

You need to delete in smaller chunks using a loop and TOP/ROWCOUNT. I have no idea what your magic number would be, so you'll have to play with it, but the point is to cause minimal usage of the transaction log and, in simple recovery, issue multiple checkpoints in between iterations of the loop so that the log space you've used can be marked for reuse. (The ...


2

In shrink action, you need to choose: "Reorganize pages before releasing unused space" And choose desidered size. Actually you don't have released space because you have still used pages ad the end of your file. Edit: You can do it via query, with instructions like this: DBCC SHRINKFILE (N'MATRIX24X7' , 449000)



Top 50 recent answers are included