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 ...

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 ...

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).

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 ...

Backing up SQL Server is a standard practice, but knowing which recovery model to use can be confusing. Use these tips to get started with your backup strategy.

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 ...

Using the Transact SQL ALTER DATABASE statement to shrink the transaction log file Open SQL Server Management Studio (SSMS) and click Query Analyzer to open the Query Analyzer window.