• Please confirm if the below points are true for full recovery model without changing the recovery model:-

    The below query will take the back up transaction log and shrink the log file:-

    USE DBNAME

    Take a DB Full bacp of DB

    Take a back up of log:-

    backup log DBNAME with no_log

    Shrink log:-

    DBCC SHRINKFILE DBNAME_Log, 10)