I have read loads of articles about the danger of shrinking and
I am under the impression that the reason is because it causes index fragmentation,
Defraging/rebuilding the index increases the transaction log e.t.c
My question is this...
If I have a large database, and I decide to remove tables, archieve data e.t.c would shrinking the database reduce the backup size?
The backup is massive and it takes a long time to copy it from one storage facility to another and also takes time to restore.
So if i clean up the database and then shrink it, will it reduce the backup size?
Thanks for listening