SQL Server Performance

Relocate of online log for Standby

Discussion in 'SQL Server Log Shipping' started by baggy, May 13, 2004.

  1. baggy New Member

    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)
  2. satya Moderator

Share This Page