Overgrown transactional log files can turn into real problems if they are not handled properly. Today SQL Server consultant Tim Chapman discusses the perils of not handling SQL Server log growth ...

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. The transaction log contains enough ...

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.

The file growth value that is configured for the SQL Server database transaction log file is 4 gigabytes (GB) or multiples thereof (for example, 8 GB, 12 GB, and so on). However, the transaction log ...

SQLserver Transaction Log Analyzer. This project is a an analyzer of the SQL server 200, 2005, 2008 Trans action logs. It requires: -SQL server 2000, 2005 or 2008 -You must build a test table that ...

Brian has specialized in Office 365, SharePoint, and SQL Server integration over the past few years, but his breadth of knowledge also includes Microsoft operating systems and Active Directory.