<

How to Shrink a Bloated Transaction Log File (SQL Server)

Posted on
4,078 Points
1,078 Views
Last Modified:
Experience Level: Beginner
5:07
Via a live example, show how to shrink a transaction log file down to a reasonable size.
0
Author:Steve Wales
0 Comments

Featured Post

PMI ACP® Project Management

Prepare for the PMI Agile Certified Practitioner (PMI-ACP)® exam, which formally recognizes your knowledge of agile principles and your skill with agile techniques.

In this article, we will show how to detach and attach a database and then show how to repair a corrupt database and attach it, If it has some errors. We will show how to detach and attach using SSMS or using T-SQL sentences.
In this article, we will see two different methods to recover deleted data. The first option will be using the transaction log to identify the operation and restore it in a specified section of the transaction log. The second option is simpler and c…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month