Post reply

Detach Log Shipping Primary?

  • October 14, 2010 at 11:19 am

    #149023

    Hi I need to move the .ldf file associated with a Log Shipping Primary. I'd like to do this without reconfiguring Log Shipping.

    Does anyone know if I can Detach / Attach a Log Shipping Primary database without it destroying the log shipping configuration? Another way to put it is will the LSN be affected by a detach / attach?

    Thanks!

  • October 14, 2010 at 11:31 am

    #1237098

    No need to detach.

    ALTER DATABASE to change the location of the file (check Books Online for the syntax)

    Take the database offline

    Move the file(s)

    Bring the database online.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • October 14, 2010 at 11:41 am

    #1237103

    Thanks Gail!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply