以下仅为参照，如果有多个实例，可能会有些许不同：
本环境是SQL Server 2005 Standard Version 64-bit 和 SQL Server 2008 Standard Version 64-bit 双实例同时安装在一个
Windows Server 2008 Standard Version 64-bit OS上：
代码
Windows Server
2008
Standard Version
64
-
bit
SQL Server 2005 Standard Version 64 - bit
查询用户库Data文件默认路径：
DECLARE @DefaultData VARCHAR ( 100 )
EXEC master..xp_regread @rootkey = ' HKEY_LOCAL_MACHINE ' ,
@key = ' Software\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer ' ,
@value_name = ' DefaultData ' ,
@DefaultData = @DefaultData OUTPUT
SELECT @DefaultData
查询用户库Log文件默认路径：
DECLARE @DefaultLog VARCHAR ( 100 )
EXEC master..xp_regread @rootkey = ' HKEY_LOCAL_MACHINE ' ,
@key = ' Software\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer ' ,
@value_name = ' DefaultLog ' ,
@DefaultLog = @DefaultLog OUTPUT
SELECT @DefaultLog
查询用户库备份文件默认路径：
DECLARE @BackupDirectory VARCHAR ( 100 )
EXEC master..xp_regread @rootkey = ' HKEY_LOCAL_MACHINE ' ,
@key = ' Software\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer ' ,
@value_name = ' BackupDirectory ' ,
@BackupDirectory = @BackupDirectory OUTPUT
SELECT @BackupDirectory
修改用户库Data文件默认路径：
EXEC master..xp_regwrite
@rootkey = ' HKEY_LOCAL_MACHINE ' ,
@key = ' Software\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer ' ,
@value_name = ' DefaultData ' ,
@type = ' REG_SZ ' ,
@value = ' D:\SQL2005\Data '
修改用户库Log文件默认路径：
EXEC master..xp_regwrite
@rootkey = ' HKEY_LOCAL_MACHINE ' ,
@key = ' Software\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer ' ,
@value_name = ' DefaultLog ' ,
@type = ' REG_SZ ' ,
@value = ' D:\SQL2005\Log '
修改用户库备份文件默认路径：
EXEC master..xp_regwrite
@rootkey = ' HKEY_LOCAL_MACHINE ' ,
@key = ' Software\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer ' ,
@value_name = ' BackupDirectory ' ,
@type = ' REG_SZ ' ,
@value = ' D:\SQL2005\DBBak '
SQL Server 2005 Standard Version 64 - bit
查询用户库Data文件默认路径：
DECLARE @DefaultData VARCHAR ( 100 )
EXEC master..xp_regread @rootkey = ' HKEY_LOCAL_MACHINE ' ,
@key = ' Software\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer ' ,
@value_name = ' DefaultData ' ,
@DefaultData = @DefaultData OUTPUT
SELECT @DefaultData
查询用户库Log文件默认路径：
DECLARE @DefaultLog VARCHAR ( 100 )
EXEC master..xp_regread @rootkey = ' HKEY_LOCAL_MACHINE ' ,
@key = ' Software\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer ' ,
@value_name = ' DefaultLog ' ,
@DefaultLog = @DefaultLog OUTPUT
SELECT @DefaultLog
查询用户库备份文件默认路径：
DECLARE @BackupDirectory VARCHAR ( 100 )
EXEC master..xp_regread @rootkey = ' HKEY_LOCAL_MACHINE ' ,
@key = ' Software\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer ' ,
@value_name = ' BackupDirectory ' ,
@BackupDirectory = @BackupDirectory OUTPUT
SELECT @BackupDirectory
修改用户库Data文件默认路径：
EXEC master..xp_regwrite
@rootkey = ' HKEY_LOCAL_MACHINE ' ,
@key = ' Software\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer ' ,
@value_name = ' DefaultData ' ,
@type = ' REG_SZ ' ,
@value = ' D:\SQL2005\Data '
修改用户库Log文件默认路径：
EXEC master..xp_regwrite
@rootkey = ' HKEY_LOCAL_MACHINE ' ,
@key = ' Software\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer ' ,
@value_name = ' DefaultLog ' ,
@type = ' REG_SZ ' ,
@value = ' D:\SQL2005\Log '
修改用户库备份文件默认路径：
EXEC master..xp_regwrite
@rootkey = ' HKEY_LOCAL_MACHINE ' ,
@key = ' Software\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer ' ,
@value_name = ' BackupDirectory ' ,
@type = ' REG_SZ ' ,
@value = ' D:\SQL2005\DBBak '
代码
Windows Server 2008 Standard Version 64 - bit
SQL Server 2008 Standard Version 64 - bit
查询用户库Data文件默认路径：
DECLARE @DefaultData VARCHAR ( 100 )
EXEC master..xp_regread @rootkey = ' HKEY_LOCAL_MACHINE ' ,
@key = ' Software\Microsoft\Microsoft SQL Server\MSSQL10.SQL2008\MSSQLServer ' ,
@value_name = ' DefaultData ' ,
@DefaultData = @DefaultData OUTPUT
SELECT @DefaultData
查询用户库Log文件默认路径：
DECLARE @DefaultLog VARCHAR ( 100 )
EXEC master..xp_regread @rootkey = ' HKEY_LOCAL_MACHINE ' ,
@key = ' Software\Microsoft\Microsoft SQL Server\MSSQL10.SQL2008\MSSQLServer ' ,
@value_name = ' DefaultLog ' ,
@DefaultLog = @DefaultLog OUTPUT
SELECT @DefaultLog
查询用户库备份文件默认路径：
DECLARE @BackupDirectory VARCHAR ( 100 )
EXEC master..xp_regread @rootkey = ' HKEY_LOCAL_MACHINE ' ,
@key = ' Software\Microsoft\Microsoft SQL Server\MSSQL10.SQL2008\MSSQLServer ' ,
@value_name = ' BackupDirectory ' ,
@BackupDirectory = @BackupDirectory OUTPUT
SELECT @BackupDirectory
修改用户库Data文件默认路径：
EXEC master..xp_regwrite
@rootkey = ' HKEY_LOCAL_MACHINE ' ,
@key = ' Software\Microsoft\Microsoft SQL Server\MSSQL10.SQL2008\MSSQLServer ' ,
@value_name = ' DefaultData ' ,
@type = ' REG_SZ ' ,
@value = ' D:\SQL2008\Data '
修改用户库Log文件默认路径：
EXEC master..xp_regwrite
@rootkey = ' HKEY_LOCAL_MACHINE ' ,
@key = ' Software\Microsoft\Microsoft SQL Server\MSSQL10.SQL2008\MSSQLServer ' ,
@value_name = ' DefaultLog ' ,
@type = ' REG_SZ ' ,
@value = ' D:\SQL2008\Log '
修改用户库备份文件默认路径：
EXEC master..xp_regwrite
@rootkey = ' HKEY_LOCAL_MACHINE ' ,
@key = ' Software\Microsoft\Microsoft SQL Server\MSSQL10.SQL2008\MSSQLServer ' ,
@value_name = ' BackupDirectory ' ,
@type = ' REG_SZ ' ,
@value = ' D:\SQL2008\DBBak '
QQ：498977166
http://szw.cnblogs.com/
研究、探讨.NET开发
转载请注明出处和作者，谢谢！
Senparc官方教程《微信开发深度解析：微信公众号、小程序高效开发秘籍》，耗时2年精心打造的微信开发权威教程，点击这里，购买正版！
