Question : I have a 225GB DB with a 390GB log file, which has only recently exploded in size. I […]
Is conditionally SQL Server log backup possible?
Question : I have a SQL Server database and right now we have weekly full backup, daily differential backup and […]
Do Log Backups depend on Differential Backups?
Question : I have the following backup strategy set up: My understanding so far, was: Differential backups do not truncate […]
Is it good idea to repair sql file?
Question : We are having an ETL process which inserts lots of data into tables. This database is set to […]
SQLServer In-Memory database and log file size unexpected increase
Question : I have a strange issue with a SQLServer 2014 (12.0.4439.1) database. I created some months ago a data […]
View Specific Transaction in LDF
Question : There was an update statement which was ran in our production environment which should not have been run. […]
Bloated transaction log and .bak backup size confusion [duplicate]
Question : This question already has answers here: Why Does the Transaction Log Keep Growing or Run Out of Space? […]
How does a transaction log backup deal with active log?
Question : What happens to the log records that maintain any open uncommitted transactions when a transaction log backup starts? […]
How can I use RMAN to show if there are archive logs that need to backed up?
Question : My main concern is knowing if the Oracle Archive Logs haven’t been backed up in a while because […]
Searching transaction logs for changes
Question : I currently have a database with an attached CMS. The CMS has about 50+ people with various permission […]