Ars Technica

Restoring MSSQL DB from transaction log questions.....

I do some consulting for a consulting firm (sorry i had to throw that in) that recently deleted some records and then realized their backups weren't running so restoring wasn't possible. Now I was ...
Network World

So I can’t use BACKUP LOG WITH TRUNCATE ONLY – but what can I do instead?

In an earlier blog entry, I talked about “Deprecated” code and I highlighted the fact that the BACKUP LOG WITH NO_LOG and BACKUP LOG WITH TRUNCATE_ONLY statements are no longer allowed in SQL Server ...
Computerworld

Avoiding ginormous transaction logs with SharePoint databases

There isn’t a week that goes by that I don’t hear or read about an organization seeing ginormous transaction log (.ldf) files, while the associated data (.mdf) file is at the size it should be when ...
TechRepublic

Help! My SQL Server Log File is too big!!!

Help! My SQL Server Log File is too big!!! Your email has been sent Overgrown transactional log files can turn into real problems if they are not handled properly. Today SQL Server consultant Tim ...
Ars Technica

How to track down the source of SQL transaction log growth?

I'm not a DBA - my knowledge of SQL is limited to install, uninstall, backup, restore, troubleshoot connectivity, that sort of thing. That said, one of the servers I manage has a database that behaves ...
dbta

Delayed Durability—The SQL Server 2014 Transaction Log Hack!

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