I have dropped one huge table from the production DB
Current DB size on disk = 264 GB
The real size of the Tables = 32.164 GB
I am going to shrink this DB. Although it is not recommended, but this is the only option i have to reclaim this space, i will do monthly archiving for this table so i am sure it will not grow to this size again
My Questions are
There are Mirroring and replication on this DB, What should i do?
Is there a way to do this with no downtime? if no, what should be the plan to do this with the minimal downtime
Is Shrinking just affect indexes or it has other impact on performance?