Home Forums SQL Server 2012 SQL 2012 - General Post Installation Changes (data directories) with SQL Server 2012 RE: Post Installation Changes (data directories) with SQL Server 2012

  • USE [master]

    GO

    EXEC xp_instance_regwrite

    N'HKEY_LOCAL_MACHINE',

    N'Software\Microsoft\MSSQLServer\MSSQLServer',

    N'DefaultData',

    REG_SZ,

    N'C:\ new data file path...'

    GO

    EXEC xp_instance_regwrite

    N'HKEY_LOCAL_MACHINE',

    N'Software\Microsoft\MSSQLServer\MSSQLServer',

    N'DefaultLog',

    REG_SZ,

    N'C:\ new log file path...'

    GO

    EXEC xp_instance_regwrite

    N'HKEY_LOCAL_MACHINE',

    N'Software\Microsoft\MSSQLServer\MSSQLServer',

    N'BackupDirectory',

    REG_SZ,

    N'C:\ new backup path...'

    GO

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato