SQL Server Performance

how to create sub-folder on the drive of clutering

Discussion in 'SQL Server Clustering' started by xuka200308, Aug 7, 2006.

  1. xuka200308 New Member

    Hi All
    i have to create 3 sub folders on the our F drive of 2 nodes SQL server 2000 clustering. the F drive is for all data files. i need 3 folders for our database file, log files and backup files. how do i create them before i install SQL server clustering? please help me.

    thanks,

    karen
  2. Argyle New Member

    Create them after install. Then move any system database log files if you want them in those folders too.http://support.microsoft.com/kb/224071/

    Make sure the SQL Servie account have full administrative access to your new folders.

  3. xuka200308 New Member

    thanks, Argyle
    but where i can create them? from primary node or active node? or i can map drive on the windows cluster to the client machine then create them? i'm confused with all these issues.

    could anyone has this idea?

    thanks in advance,

    karen
  4. satya Moderator

    From primary node and ensure it is the active node.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
  5. xuka200308 New Member

    thanks, Satya


    karen

Share This Page