I have a db MSSQL for CAUIM. This db is mssql standart 2014 and weight it 1.27 tb to support 2162 devices.
All days to the 00:00 hours we have a backup full to CA_UIM db, this backup taking 4 to 5 hours in finished, during the backup the disk L (transaction log) increase to 90% average, the space for this disk is 400gb.
Is normal this increase on the disk (Transaction logs)?
If on the future we have more devices to monitoring and the weight of the db is 2tb and the backup take 6 hours to finished we need increased to 600gb to the disk L?.