Question : I have seen a lot of blogs stating that shrinking is not a good habit as it will […]
Tag: shrink
What’s the difference between “shrink” file vs simply reducing the initial size?
Question : I’m totally new in DB Administration. So i got confused about the “file shrink” functionality offered on SQL […]
Should I run multiple DBCC Shrinkfile if files are in different disk arrays?
Question : We just deleted about 45% of the data in a database, and we want to reduce the size […]
Is it a good idea to shrink prior to a SQL Server upgrade to a new instance
Question : We currently have a 100GB database which is in simple recovery mode, and it is running on 2008 […]
Best Way to Reduce the Size of 8 TB DB?
Question : We have a legacy SQL Server 2005 DB that is 8 TB in size. We will be purging […]
How do I reduce SharePoint 2010 SQL server log files? [duplicate]
Question : This question already has answers here: Why Does the Transaction Log Keep Growing or Run Out of Space? […]
Why Does the Transaction Log Keep Growing or Run Out of Space?
Question : This one seems to be a common question in most forums and all over the web, it is […]
How to compress a non-shrinkable table with nvarchar(max) fields?
Question : We have a serious problem which was on our minds for pretty much two weeks already. We have […]
Shoudn’t DBCC SHIRNKFILE(Data_File, 0) command shrink data file to the last allocated extent?
Question : I have a datafile with the following parameters: When I execute DBCC SHRINKFILE (DBAtools_data,1), it shows the following […]
Shrink Tempdb log file when reaching a specific size [closed]
Question : Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this […]