News

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 ...
Delayed durability was announced late in the SQL Server 2014 development cycle, but offers something that many SQL Server professionals have wanted for years—the ability to disable transaction logging ...
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).
The transaction logs hold temporary data and just deleting or misplacing these files will impact the health of the database. So, to truncate the transaction logs without backup, you need to find a way ...
some operation's I do can at times grow the trans logs quickly.. so, for a quick and dirty way to shrink the log I'll back it up from query analyzer<br><br>backup log 'database'<br>with truncate ...
“For them, each transaction is money,” Kelly said. More details will be given about the new features in SQL Server 2014 in the months ahead.
He kinda answered it Coleman. You'll use the transaction logs to do restores between backups so really it is up to your comfort level.