Post reply

Moving LDF or MDF file

  • February 18, 2011 at 6:57 am

    #245876

    Can I move the location of LDF or MDF file of replicated (Transactional) database? Would it hurt replication?

    Thanks.

    Am

  • February 18, 2011 at 7:00 am

    #1288822

    Yes yuo can. Look up ALTER DATABASE in books online, you can use that to change the phycial names that SQL knows, then take the DB offline, move the files and bring the DB back 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

  • February 18, 2011 at 7:06 am

    #1288828

    Thanks, will try tonight.

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

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