SQL Server Performance Forum – Threads Archive

Relocate Log of Standby Database

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 ie without having to re-dump the original and copy of standby.
I believe if I detach the database and try to re-attach from new location it will recover the database thus not allowing further log restores. I can’t dump the read-only/standby database, it won’t let me. Any other thoughts appreciated. Rick (aka baggy)[?]

http://www.microsoft.com/sql/techinfo/tips/administration/movingtransactionlogs.asp as specified only the way is to use DETACH & ATTACH method if you want to move the .LDF file to another location. And to do so you must stop the LOG SHIPPING pattern until you reattach/restore the standby database. (Moving to General DBA section as its appropriate) Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

>> And to do so you must stop the LOG SHIPPING pattern until you reattach/restore the standby database. Re-attaching the database recovers it thus halting the ability to resume ‘the LOG SHIPPING pattern ‘ . I need to know if I can re-attach without recovering if re-attach is the only option avaialbe. With regard to the correct forum, I thought this was relevenat to Log shipping as Log shipping is causing my problem, ie if it wasn’t in the Standby mode changing the Log location wouldn’t be an issue. Rick.

If you’re changing any of the database configuration then you must disable the participation of database such as in replication, log shipping etc. Otherwise restore the complete database on the standby server and use MOVE clause in the RESTORE statement, then re-enable the log shipping to affect the settings. Either way it should be stopped to configure. Lastly, the whole issue is to move the LOG file and its a normal DBA functionality and I thought this would be the appropriate forum. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Ok, thanks. I’ll just have to dump the primary and load it over the secondary at the same time re-locating the log file.

]]>