I found a couple of 'question' regarding shrinking big datafiles but I think that is not very accurate to my situation. So here is my question
I have a big database with almost 8TB of Data File Size and almost 160 GB of log file The database is in offline status
Shrink process due to the big size of the data file will take a long time so I'm not sure how to proceed in order to avoid any problem in the instance.
One option that I have in mind is to create a new data file and then, copy the tables to the new data files and finally shrink the old data file