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:


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.

Comments are closed