Can I shrink log shipped database log file?

How do you shrink log file when log shipping is implemented in database?

To shrink Log file you have to run following command. So here we used NOTRUNCATE option because in log shipping transaction log sequence important if you run the normal Shrink file or with truncate file option then log shipping will be failed. So run Shrink File with NOTRUNCATE option.

How do I reduce the size of my database log?

To shrink a data or log file using SQL Management Studio:1In Object Explorer, connect to an instance of the SQL Server Database Engine and then expand that instance.2Expand Databases and then right-click the database that you want to shrink.3Point to Tasks, point to Shrink, and then click Files.How to shrink the transaction log file in SQL Server | FAQs - PRO-FACE

Is it safe to shrink SQL log file?

It's safe, but do it at a quiet time when there's low transactional activity. It's recommended to shrink the log to its minimal size and then grow it to its normal size (this will ensure the correct number of VLFs (internal virtual log files) are created, which improves performance for logged commands).

How do I compress a transaction log file?

Shrink the transaction log1Right-click the database and select Tasks -> Shrink -> Files.2Change the type to Log .3Under Shrink action, select Release unused space and click OK.Truncate and shrink log files in SQL Server - - Rackspace