• Run following command to shrink log file if you have enabled the log shipping on your database:

    DBCC SHRINKFILE ( ‘Database_log’ , NOTRUNCATE)