Thoughts on the following:
My SHRINKFILE on a Reporting DB consisting of 187 GB allocated, 100 GB used -- is taking several hours. I recently learned that after I restore the Reporting DB (from a prod DB backup) I can DROP 2 very large tables in the Reporting DB (occupying upwards of 80% of the space).
Will the SHRINKFILE run faster after the DROP of the 2 tables? (or will it take the same amount of time?)
Note, I have to restore the entire Reporting DB 1st due to the fact that Stored Proc's, Views, etc are used in the Reporting DB environment.
My SHRINKFILE on a Reporting DB consisting of 187 GB allocated, 100 GB used -- is taking several hours. I recently learned that after I restore the Reporting DB (from a prod DB backup) I can DROP 2 very large tables in the Reporting DB (occupying upwards of 80% of the space).
Will the SHRINKFILE run faster after the DROP of the 2 tables? (or will it take the same amount of time?)
Note, I have to restore the entire Reporting DB 1st due to the fact that Stored Proc's, Views, etc are used in the Reporting DB environment.