How to Move SQL Server Log Shipping Secondary Database Files

If disk space on your SECONDARY side is full and  you want to move one of your databasefile to other location.

You can manage in 3 steps:

ALTER DATABASE LogShipped_DB

MODIFY FILE ( NAME = myLogShip, FILENAME = ‘D:\SQLMonitor\LogShip.mdf’ );

With this command, you have indicated that you are going to move datafile to sql server. Of course this command like others will be run on Secondary side. It would be better to disable restore jobs.

Secondly, shut your SQL SERVER down and copy your datafile to new location.

And lastly start your SQL SERVER. New logs will be applied to your database that have new locations.