Post reply

Moving data file

  • April 8, 2013 at 1:20 pm

    #270939

    For a db involved in db mirroring, what steps do I take to move its data and log file to another drive?

  • April 9, 2013 at 7:44 am

    #1604809

    Break the mirror, perform the move, restart mirroring. The move doesn't break the log chain so there should be no need to re-seed the mirror. This of course all depends upon the size of the DB as that drives the downtime to move the data and log files.

    - Tim Ford, SQL Server MVPhttp://www.sqlcruise.comhttp://www.thesqlagentman.com http://www.linkedin.com/in/timothyford

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

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