transaction-log Archives

Log file won’t shrink – suggestions?

By adminPosted on March 28, 2023

Question : I have a 225GB DB with a 390GB log file, which has only recently exploded in size. I […]

By adminPosted on March 27, 2023

Question : I have a SQL Server database and right now we have weekly full backup, daily differential backup and […]

By adminPosted on March 26, 2023

Question : I have the following backup strategy set up: My understanding so far, was: Differential backups do not truncate […]

By adminPosted on March 26, 2023

Question : We are having an ETL process which inserts lots of data into tables. This database is set to […]

By adminPosted on March 26, 2023

Question : I have a strange issue with a SQLServer 2014 (12.0.4439.1) database. I created some months ago a data […]

By adminPosted on March 25, 2023

Question : There was an update statement which was ran in our production environment which should not have been run. […]

By adminPosted on March 21, 2023

Question : This question already has answers here: Why Does the Transaction Log Keep Growing or Run Out of Space? […]

By adminPosted on March 19, 2023

Question : What happens to the log records that maintain any open uncommitted transactions when a transaction log backup starts? […]

By adminPosted on March 18, 2023

Question : My main concern is knowing if the Oracle Archive Logs haven’t been backed up in a while because […]

By adminPosted on March 18, 2023

Question : I currently have a database with an attached CMS. The CMS has about 50+ people with various permission […]