SQL Server Performance Forum – Threads Archive

how to create sub-folder on the drive of clutering

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

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.

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

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.

thanks, Satya
karen

]]>