Post reply

how to set up transaction logs on local disk in cluster server sql server 2008

  • January 16, 2014 at 6:21 am

    #288423

    Question: Is it feasible to store Database Log files on local drive in clustered environment, and if so, how you set it so files are moved to the other node in case of failure. Lets say you have node1 and node 2, the goal is to set them active/passive clustered, is it possible to have the log files stored in local drives?

  • January 16, 2014 at 6:59 am

    #1680637

    Database files must be on shared storage when you have a clustered SQL Server.

    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

  • January 16, 2014 at 7:02 am

    #1680639

    Gail, thank you... How about temp files in SQL 2008?

  • January 16, 2014 at 7:37 am

    #1680654

    On shared storage unless you make some unsupported hack (which I am not going to explain).

    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

  • January 16, 2014 at 7:47 am

    #1680665

    Gail, thank you.

Viewing 5 posts - 1 through 4 (of 4 total)

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