Bayt.com

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

Does shrinking a SQL Server transaction log remove transactions from the log?

Log Management Programming SQL Server 2000 2008
user-image
Question added by Md Haidar Ali Khan , DBA , Amwaj Qatar
Date Posted: 2016/03/15
Upvote (0) Views (3) Followers (2) Answers (2) Report Question
Write an Answer
Register now or log in to answer.
Rohan Wiese
by Rohan Wiese , Working as Freelancer , Freelancer

SQL Server Log Analyzer is one of the best software that can easily remove transactions from the log of SQL Server.

https://www.arysontechnologies.com/sql-log-analyzer/

Muhammad Shafiq
by Muhammad Shafiq , Oracle Apps & MS.SQL DBA , Ministry of Culture & Information KSA

shrinking the log is actually clear the log.The log is basically a list of operations that have been performed, and is used as a reference for rollbacks, restores, checkpoints, etc.

Write Your Answer
More Questions Like This