Post reply

Use mount points for sql server 2008 r2 cluster

  • August 27, 2011 at 12:08 am

    #256268

    Hi,

    We want to implement Mount points for sql server 2008 r2 cluster.

    If I mounted Drive D and then created the folder for Data files, log files and tempdb as below

    D:\Data -> for data files

    D:\Logs -> for log files

    D:\TempDb -> for tempdb

    Question:

    In above mount points, can we configure that the folder1 (D:\Data) can have 1 LUN, folder2 (D:\Logs) can have LUN2 and folder3 (D:\tempdb) can have LUN3 on SAN?

    or we can carve onlu one LUN for drive D on SAN?

    Please advice

    Thanks

  • August 29, 2011 at 4:18 pm

    #1374763

    Hi,

    I do have the same question. Please advice

    Thaks

  • August 30, 2011 at 2:41 am

    #1374847

    Those can be on different LUNs, and in fact I would recommend it. If possible, I would even recommend them to be on different storage arrays or even different SAN fabric if possible, to reduce the likeliness of losing both the transaction log and the data files. Keep in mind, SANs can fail too.


    Ole Kristian Velstadbråten Bangås - Virinco - Facebook - Twitter

    Concatenating Row Values in Transact-SQL[/url]

  • August 30, 2011 at 3:54 pm

    #1375270

    Thank you.

    Windows admin created mount points as below:

    D:\Data -> for data files

    D:\Logs -> for log files

    D:\TempDb -> for tempdb

    Now before installing sql server, can we create a folder called INS1 inside the mount point (ex:D:\Data\INS1 ) and have the data files under D:\Data\INS1 ?

    Thanks

  • August 31, 2011 at 1:18 am

    #1375325

    It's not just that you can, you do actually have to.


    Ole Kristian Velstadbråten Bangås - Virinco - Facebook - Twitter

    Concatenating Row Values in Transact-SQL[/url]

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

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