将下面代码复制到查询分析器中,修改代码中的D:\MSSQL\Data为你想要设置的默认存放目录,然后执行即可。
--
1.更改資料文件默認存放路經:
EXEC xp_instance_regwrite
@rootkey = ' HKEY_LOCAL_MACHINE ' ,
@key = ' Software\Microsoft\MSSQLServer\MSSQLServer ' ,
@value_name = ' DefaultData ' ,
@type = REG_SZ,
@value = ' D:\MSSQL\Data '
GO
-- 2.更改日志文件默認存放路經:
EXEC master..xp_instance_regwrite
@rootkey = ' HKEY_LOCAL_MACHINE ' ,
@key = ' Software\Microsoft\MSSQLServer\MSSQLServer ' ,
@value_name = ' DefaultLog ' ,
@type = REG_SZ,
@value = ' D:\MSSQL\Data '
GO
EXEC xp_instance_regwrite
@rootkey = ' HKEY_LOCAL_MACHINE ' ,
@key = ' Software\Microsoft\MSSQLServer\MSSQLServer ' ,
@value_name = ' DefaultData ' ,
@type = REG_SZ,
@value = ' D:\MSSQL\Data '
GO
-- 2.更改日志文件默認存放路經:
EXEC master..xp_instance_regwrite
@rootkey = ' HKEY_LOCAL_MACHINE ' ,
@key = ' Software\Microsoft\MSSQLServer\MSSQLServer ' ,
@value_name = ' DefaultLog ' ,
@type = REG_SZ,
@value = ' D:\MSSQL\Data '
GO