Post reply

Move transaction log location

  • May 30, 2002 at 5:53 am

    #173008

    I want to change transaction log location to other drive.

    Is there a way to change location except detach/attach or restore or adding other log file and shrink the origional one to 1 mb.

    Prakash

    Prakash Heda
    Lead DBA Team - www.sqlfeatures.com
    Video sessions on Performance Tuning and SQL 2012 HA

  • May 30, 2002 at 6:24 am

    #429991

    No you will have to detach/attach to get it to work properly. You could shirnk the first file to 1MB and set as maximum then create a secound Log file but that really seems a waste.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

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

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