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 […]