Learn what the transaction log is, how it works, and how it helps SQL Server to restore and recover databases from backups or disasters. Skip to main content LinkedIn Articles ...

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.

When you finish the restore operation and recover the database, the recovery process is executed to ensure the integrity of the database. For more information about the recovery process, see Restore ...

However, sometimes, the transaction log files get deleted accidentally. Also, it can get corrupted due to virus infection, hardware problem, or various other reasons. If the transaction log file is ...

Each database has at least one physical transaction log and one data file that is exclusive to the database for which it was created. SQL Server keeps a buffer of all of the changes to data for ...

We have to perform this backup of the transaction log using either SQL Server Management Studio (SSMS) ... Shrinking an already ginormous SharePoint database transaction log. Jan 11, 2016 4 mins ...

Technical documentation for Microsoft SQL Server, tools such as SQL Server Management Studio (SSMS) , SQL Server Data Tools (SSDT) etc. - MicrosoftDocs/sql-docs ...