Home Forums SQL Server 2008 SQL Server 2008 - General move transaction log to a different drive. RE: move transaction log to a different drive.

  • October 11, 2012 at 7:29 pm

    #1548409

    Perry Whittle (10/11/2012)

    That is correct, you cannot drop the first created (primary) data or log file . If you want to move this you will incur some minimal downtime.

    Create your alter database ... modify file statement and run it. Then perform the following

    • take the database offline.
    • Copy the log file to the new location
    • once copied bring the database back online
    • Once the database is online delete the old file

    Thank you Perry for your suggestion. As MysteryJimbo suggested We have ordered additional disc and created additional transaction log to mitigate the risk of running out of space in transaction log.