Jan 30 2023 10:42 AM
MSSQL DATA is exceeding disk usage. It seems there would be a way to limit data base impact on hard drive. Attempts to limit in autogrowth section are being overwritten somewhere and and locking the hard drive up.
MSSQLDATA is at 53g Logs is at 89.6g
What settings can I deploy to limit impact on hard drive and allow us to troubleshoot?
Jan 30 2023 10:51 PM
@RobotRon4u , is the database in full recovery mode? Then you have to run frequently Log backups to release VLF for re-use, otherwise the database Log file keeps growing.
Jan 31 2023 05:36 AM - edited Jan 31 2023 06:11 AM
Thank you for your response. If we backup the log file, won't the hard drive still have all the data and be over run?
What good is the log file? Is it necessary? We are gathering log file size about 1 gig a minute. Something just doesn't seem like we have it set up right on the front end?
The predominant file is SQLDump####.mdmp "Crash Dump File". We get ten 17mb files of this type a minute. dropping into our MSSQL>Log file.
Jan 31 2023 11:29 PM