AnsweredAssumed Answered

Transaction log disk increase during backup on CANIS

Question asked by Miller2012 on Jun 26, 2018
Latest reply on Jun 27, 2018 by Miller2012

Hi All.


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?.


Best regards.