Post reply

How To Move Transaction Logs to a different drive with minimum downtime if any?

  • October 25, 2006 at 11:02 am

    #153254

    I have a problem on a very busy server and have just noticed the logs and data files residing on the same drive. Whats the best way to move the transaction logs to a different drive whilst minimising distruption?

    Mucho thx

  • October 25, 2006 at 12:00 pm

    #667948

    If minimizing disruption means "0" downtime you need to add a second transaction log file on the "other" drive. Then mark the first one as fixed length and shrink it when you can. That will leave you with minimun size tlog on the original drive and another on the correct drive.

    Now if you can take some downtime you can backup the log, shrink it and

    IF using 2005 you can use ALTER DATABASE to set the db offline, move the file in the file system and use ALTER DB to update file path and set the DB Back Online

    IF is 2000 you will have to detach, move file and attach.

    HTH


    * Noel

  • October 27, 2006 at 6:19 am

    #668458

    Thanks Noel,

    New problem. Now when I try to browse to the new directory via enterprize manager its only showing me the one existing drive. I'm confused as when I look on the server it has 4 drives available. Any ideas why the others don't show ? Or do I just have to use scripts instead?

     

    Cheers

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

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