SQL Server Performance Forum – Threads Archive
Relocate of online log for StandbyI 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 threadhttp://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=4149 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.