When i apply alter column on table, it full log file and disk too, and failed alter operation. Why this happened even table size is less than free disk? Can please suggest a way to complete this operation without making free space in disk.
Scenario :
- Alter column size from numeric(9,10) to numeric(18,6)
Statistics :
- Table size - 40 GB
- Table rows - 40 million
- Disk free space where this table located - 50 GB
- Database Recovery model : Full and configured mirroring
- SQL Server version - 2012 ENT
Aucun commentaire:
Enregistrer un commentaire