Change LDF file location when sql server in Read-Only

• shuzi

  Say Hey Kid

  Points: 684

  More actions

  February 2, 2009 at 1:55 pm

  #73448

  Hi, currently our sql server 2000 is in read-only state (being log shipped),

  is there anyway to change the ldf file location to different drive? thanks

• Jason Crider

  SSCertifiable

  Points: 6019

  More actions

  February 2, 2009 at 10:09 pm

  #936907

  Do you have the ability to disable log shipping to make the change?

  MCITP, Database Administrator
  A hodgepodge of Information Technology and Life
  LinkedIn Profile
  My Twitter