Relocate of online log for Standby | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Relocate of online log for Standby

I have a standby database (2000 Standard) which is in the state of loading or read-only at any one time. I would like to know of a convenient way to move the online log (.ldf) to another drive with minimal distruption. If I try to detach and re-attach I believe it will recover the database thus stopping me from continuing to log ship. Database backups cannot be made in this mode. Any ideas would be appreciated. Rick (aka bagy)
Refer to your thread which was moved to appropriate forum (an email will be sent by the forum application). Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.