16 сент. 2023 г. · It can take a very long time to shrink databases with LOB data, because shrink has to trawl those LOB chains again and again.

8 июл. 2010 г. · Is there a way to approximate how long a shrink will take on a SQL Server database? Are there tools available that could provide some guesstimate?

15 авг. 2009 г. · Going from 94 to the end took about 5 hours, by the way. The entire operation took around 12 hours. Tags: tech, database, mssql.

16 сент. 2023 г. · We have purged some data and we are trying to shrink the file. Doing so, it is taking more time. (i.e. > 9 hours).

2 нояб. 2023 г. · This article describes how to shrink a database in SQL Server by using Object Explorer in SQL Server Management Studio or Transact-SQL.

20 апр. 2017 г. · I am trying to shrink the Data file to 687GB by using a following Command: USE [TestDB] GO DBCC SHRINKFILE (N'TestDB' , 687017) GO And there is no blocking.

9 сент. 2019 г. · I have performed a shrink on a database in the past. It was on a logging database where we chose to reduce the logging from 730 days to 90 days.

3 дек. 2018 г. · However the DBCC SHRINKFILE on each is taking MANY hours to run. For example shrinking an 800 GB database down to 120 GB takes over 15 hours. How to detect DBCC ShrinkDatabase completion percentage? When is it OK to shrink a Database? - DBA Stack Exchange Другие результаты с сайта dba.stackexchange.com

4 июн. 2021 г. · Also, this process could take about 20 to 25 minutes, depending on your computer's performance. (Bonus: if you don't already have a generic data ...

25 янв. 2004 г. · I had a 27G data file where only 17G was allocated on one of my servers. The shrink took 3-4 hours to finish, and this was on a 4-2.8Ghz CPU ...