• Not very relevant any more, and I'm only posting it as a bit of trivia, but there is also a default path for full-text catalogs there.

    I wrote a script years ago to run against all of my sQL Servers to make sure the default paths were set according to the standards. I also include calls to xp_create_subdir to make sure the paths I set actually exists.

    Declare @DataDir nvarchar(4000),

    @LogDir nvarchar(4000),

    @BakDir nvarchar(4000),

    @FTDir nvarchar(4000),

    @DefDataDir nvarchar(4000),

    @DefLogDir nvarchar(4000),

    @DefBakDir nvarchar(4000),

    @DefFTDir nvarchar(4000),

    @Instance sysname

    Set @Instance = IsNull('\' + Cast(ServerProperty('InstanceName') as sysname), '')

    Set @DefDataDir = 'H:\mssql\data' + @Instance

    Set @DefLogDir = 'O:\mssql\data' + @Instance

    Set @DefBakDir = 'E:\mssql\bak' + @Instance

    Set @DefFTDir = 'H:\mssql\FTData' + @Instance

    Exec xp_instance_regread N'HKEY_LOCAL_MACHINE',

    N'Software\Microsoft\MSSQLServer\MSSQLServer',

    N'DefaultData',

    @DataDir output,

    'no_output'

    Exec xp_instance_regread N'HKEY_LOCAL_MACHINE',

    N'Software\Microsoft\MSSQLServer\MSSQLServer',

    N'DefaultLog',

    @LogDir output,

    'no_output'

    Exec xp_instance_regread N'HKEY_LOCAL_MACHINE',

    N'Software\Microsoft\MSSQLServer\MSSQLServer',

    N'BackupDirectory',

    @BakDir output,

    'no_output'

    Exec xp_instance_regread N'HKEY_LOCAL_MACHINE',

    N'Software\Microsoft\MSSQLServer\MSSQLServer',

    N'FullTextDefaultPath',

    @FTDir output,

    'no_output'

    Select Data = @DataDir, Logs = @LogDir, BAK = @BakDir, FTCatalogs = @FTDir

    If IsNull(@DataDir, '') <> @DefDataDir

    Begin

    Exec xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'DefaultData', REG_SZ, @DefDataDir

    End

    If IsNull(@LogDir, '') <> @DefLogDir

    Begin

    Exec xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'DefaultLog', REG_SZ, @DefLogDir

    End

    If IsNull(@BakDir, '') <> @DefBakDir

    Begin

    Exec xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'BackupDirectory', REG_SZ, @DefBakDir

    End

    If IsNull(@FTDir, '') <> @DefFTDir

    Begin

    Exec xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'FullTextDefaultPath', REG_SZ, @DefFTDir

    End

    Exec xp_instance_regread N'HKEY_LOCAL_MACHINE',

    N'Software\Microsoft\MSSQLServer\MSSQLServer',

    N'DefaultData',

    @DataDir output,

    'no_output'

    Exec xp_instance_regread N'HKEY_LOCAL_MACHINE',

    N'Software\Microsoft\MSSQLServer\MSSQLServer',

    N'DefaultLog',

    @LogDir output,

    'no_output'

    Exec xp_instance_regread N'HKEY_LOCAL_MACHINE',

    N'Software\Microsoft\MSSQLServer\MSSQLServer',

    N'BackupDirectory',

    @BakDir output,

    'no_output'

    Exec xp_instance_regread N'HKEY_LOCAL_MACHINE',

    N'Software\Microsoft\MSSQLServer\MSSQLServer',

    N'FullTextDefaultPath',

    @FTDir output,

    'no_output'

    Select Data = @DataDir, Logs = @LogDir, BAK = @BakDir, FTCatalogs = @FTDir

    Exec xp_create_subdir @DataDir

    Exec xp_create_subdir @LogDir

    Exec xp_create_subdir @BakDir

    Exec xp_create_subdir @FTDir


    My blog: SQL Soldier[/url]
    SQL Server Best Practices:
    SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]