News

OK, I originally posted this in the Programmers forum without thinking (out of habit)...I'm trying to recover an earlier version of a database from a tape. I've got the bak file and all of the ...
Product Reviews. Log Explorer unlocks your SQL Server Transaction Logs. A must-have tool for the professional DBA. By Mike Gunderloy; 01/09/2002; Lumigent calls this application a "transaction ...
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 ...
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 this article we’ll examine how transaction logs are used in Microsoft SQL Server, maintenance and potential problems with them, how they can be used to restore a database, and finally ...
But SQL Server itself provides you with no way to see what's in the transaction log. If something goes wrong with your database, you can restore from a backup -- but there's no way to see in advance ...