In this article, we found out about How to know whether index fragmentation has occurred or not?

Below are steps to shrink the database log file

1. Take the backup of TestDB database

2. Run below query to get logical log file name 

Error : arithmetic overflow error converting expression to data type int.