Reduce primary DATAFILE size for an SQL Server Database 2016

0 votes

0 answers

29 views

sql-server sql-server-2016 shrink

                          In an AG always on configuration (primary) I have a database with 10TB datafile, 50% of the datafile is  a free space. Then, I want to reduce this DATAFILE from 10TB to 8TB. How to proceed for that without doing a shrink?
If there is no way other than shrink, how to estimate the time it will take?
                        

Asked by user2106896

Apr 25, 2024, 09:04 AM
Last activity: Apr 25, 2024, 04:36 PM

Reduce primary DATAFILE size for an SQL Server Database 2016

Related Questions