Our normal practices for backing up SQL servers is to use the regular SQL backup tools to perform full, differential and transaction log backups and this has always worked fine. Recently we ...

If the transaction log is growing too large then you should increase the frequency of log backups. (The Full database backup does not actually truncate the transaction log at all).

In SQL Server 2005 and later, you can create a transaction log backup while a full or differential backup is occurring, but the log backup will not truncate the log due to the fact that the entire ...

We have to perform this backup of the transaction log using either SQL Server Management Studio (SSMS) or T-SQL.

Transaction log backup – Used to back up all the transaction log records created since the last full backup. It allows point-in-time recovery of SQL Server databases until the previous transaction log ...

I would like to ask about transaction log backups. I have a transaction log that is around 16gigs I have started to do full database backups every night. To my understanding a full database backup ...

Delayed durability offers something that many SQL Server professionals have wanted for years-the ability to disable transaction logging. Why turn off the transaction log? You can accelerate ...