The transaction log file contains the SQL Server transactions of the database. It basically records the database transactions and the changes made by the transactions to the database. The logs are ...

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

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.

I have a SQL 2000 SP4 server and MOM 2005 is reporting that the tempdb database log file is getting to large. Sure enough, it the templog.ldf file is a little over 9GB in size.I honestly don't ...

Is there a way in which I can mov a databse from one server to another? I've been developing a database on my localhost, and when I come to move it online, I'll want to be able to save myself the ...

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

SQL Server transaction logs A transaction log is a sequential record of all changes made to the database while the actual data is contained in a separate file.