Post reply

where to place datafiles?

  • August 25, 2008 at 11:38 am

    #130989

    hi,

    can we place datafiles on D drive in a clustered sql server 2005?

  • August 25, 2008 at 11:52 am

    #862694

    It's kinda hard to answer your question without knowing what is the D drive.

    Is it a local drive? Mapped drive? SAN drive? etc


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • August 25, 2008 at 12:03 pm

    #862700

    are you already clustering?

    I want to mention a document you might want to read before clustering.

    Titled: Failover Clustering for Microsoft SQL Server 2005 and SQL Server 2005 Analysis Services

    do you have the Pre Clustering checklist?

    and afterwards run clusdiag.exe to make sure everything works right

    Our files are not local. They are on the netapp.

    make sure your .ldf, .trn, .bak, and .mdf are not on the same drives.

    Are you going for an Active-Active or Active-Passive mode?

  • August 25, 2008 at 1:37 pm

    #862759

    the D drive is on SAN and we implementing Active/Passive/Active clustering

  • August 25, 2008 at 1:54 pm

    #862768

    how many nodes\sql instances are in the cluster

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

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

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