To see the longest running transaction on your SQL Server instance, run the following statement. Log truncation cannot occur during a backup or restore operation. In SQL Server 2005 and later ...

Well, the official “Deprecated Database Engine Features in SQL Server 2005 ... Note that truncation will free up space within the transaction log for new transactions but will not reduce ...

Locate the database that has the ginormous .ldf file, and use either of the following sets of steps to shrink the transaction log file down to a reasonable size: Using the Transact SQL ALTER ...

I have a transaction log that is around 16gigs I have started to do full database backups every night. To my understanding a full database backup will truncate the non active portion of the ...

hi...<BR><BR>i have this problem with the sql server ver 6.5 ( i know i need to upgrade but $$ is not so kind to me at the moment :0)).<BR><BR>how to increase the Log ...

SQL Server transaction logs A transaction log is ... Depending upon how you are trying to shrink the log, you may or may not see immediate results. Ideally, shrinking should be performed on ...