In order to keep your SQL Server database running smoothly, you need to perform backups on a regular basis. One of the most important backups you need to perform is a backup of the transaction log.
How often you need to backup the transaction log depends on a number of factors, including the size of your database, the number of transactions that are taking place, and the amount of data that is being changed.
Generally, you’ll want to backup the …
Transaction log not shrinking after backup is a common issue that can occur when taking transaction log backups. The transaction log may not shrink after a backup is taken for a number of reasons, including the following:
– The backup may not have been successful. Make sure that you have a complete and successful backup before continuing.
– The transaction log may be full. If the transaction log is full, the backup process will not be able to truncate the …
