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).
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.
Results that may be inaccessible to you are currently showing.
Hide inaccessible results