I have a large (90 gb) database. About half of the space is taken up by two tables that are no longer used. I intend to truncate these two tables and as I understand things this won't free up the space (on the disk) assigned to this database until I shrink it. I don't want to shrink it at the moment.
There is an overnight backup process. Will it be possible for me restore this database to a server than only has 50gb space free or will the restore create a 90gb database that needs a shrink?
Aucun commentaire:
Enregistrer un commentaire