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

Computer database software such as Microsoft's SQL Server benefits all types of businesses, as it makes recordkeeping fast, flexible and secure. SQL Server lets you disconnect a database from the main ...

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

I'm trying to recover an earlier version of a database from a tape. I've got the bak file and all of the TRNs in a folder on a different server (wanted to restore it to our testlab sql server). From ...

In the past, the question of how to perform auditing under SQL Server has had a simple answer: Do it yourself. But now, SQL Server 2000 has eased the burden of auditing by introducing an extensive and ...

Its been a while... We just converted from a Progress Database to SQL and we are noticing that the log files are growing like crazy. No one here has any previous experience with SQL as we are learning ...

While SQL Server 2008 was little more than a service-pack level upgrade, the 2012 version of Microsoft’s database has a boatload of new features and delivers solid performance improvements.