以下仅为参照，如果有多个实例，可能会有些许不同：

本环境是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='SoftwareMicrosoftMicrosoft SQL ServerMSSQL.1MSSQLServer',

@value_name='DefaultData',

@DefaultData=@DefaultData OUTPUT

SELECT @DefaultData

查询用户库Log文件默认路径：

DECLARE @DefaultLog VARCHAR(100)

EXEC master..xp_regread @rootkey='HKEY_LOCAL_MACHINE',

@key='SoftwareMicrosoftMicrosoft SQL ServerMSSQL.1MSSQLServer',

@value_name='DefaultLog',

@DefaultLog=@DefaultLog OUTPUT

SELECT @DefaultLog

查询用户库备份文件默认路径：

DECLARE @BackupDirectory VARCHAR(100)

EXEC master..xp_regread @rootkey='HKEY_LOCAL_MACHINE',

@key='SoftwareMicrosoftMicrosoft SQL ServerMSSQL.1MSSQLServer',

@value_name='BackupDirectory',

@BackupDirectory=@BackupDirectory OUTPUT

SELECT @BackupDirectory

修改用户库Data文件默认路径：

EXEC master..xp_regwrite

@rootkey='HKEY_LOCAL_MACHINE',

@key='SoftwareMicrosoftMicrosoft SQL ServerMSSQL.1MSSQLServer',

@value_name='DefaultData',

@type='REG_SZ',

@value='D:SQL2005Data'

修改用户库Log文件默认路径：

EXEC master..xp_regwrite

@rootkey='HKEY_LOCAL_MACHINE',

@key='SoftwareMicrosoftMicrosoft SQL ServerMSSQL.1MSSQLServer',

@value_name='DefaultLog',

@type='REG_SZ',

@value='D:SQL2005Log'

修改用户库备份文件默认路径：

EXEC master..xp_regwrite

@rootkey='HKEY_LOCAL_MACHINE',

@key='SoftwareMicrosoftMicrosoft SQL ServerMSSQL.1MSSQLServer',

@value_name='BackupDirectory',

@type='REG_SZ',

@value='D:SQL2005DBBak'

复制代码 代码如下:

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='SoftwareMicrosoftMicrosoft SQL ServerMSSQL10.SQL2008MSSQLServer',

@value_name='DefaultData',

@DefaultData=@DefaultData OUTPUT

SELECT @DefaultData

查询用户库Log文件默认路径：

DECLARE @DefaultLog VARCHAR(100)

EXEC master..xp_regread @rootkey='HKEY_LOCAL_MACHINE',

@key='SoftwareMicrosoftMicrosoft SQL ServerMSSQL10.SQL2008MSSQLServer',

@value_name='DefaultLog',

@DefaultLog=@DefaultLog OUTPUT

SELECT @DefaultLog

查询用户库备份文件默认路径：

DECLARE @BackupDirectory VARCHAR(100)

EXEC master..xp_regread @rootkey='HKEY_LOCAL_MACHINE',

@key='SoftwareMicrosoftMicrosoft SQL ServerMSSQL10.SQL2008MSSQLServer',

@value_name='BackupDirectory',

@BackupDirectory=@BackupDirectory OUTPUT

SELECT @BackupDirectory

修改用户库Data文件默认路径：

EXEC master..xp_regwrite

@rootkey='HKEY_LOCAL_MACHINE',

@key='SoftwareMicrosoftMicrosoft SQL ServerMSSQL10.SQL2008MSSQLServer',

@value_name='DefaultData',

@type='REG_SZ',

@value='D:SQL2008Data'

修改用户库Log文件默认路径：

EXEC master..xp_regwrite

@rootkey='HKEY_LOCAL_MACHINE',

@key='SoftwareMicrosoftMicrosoft SQL ServerMSSQL10.SQL2008MSSQLServer',

@value_name='DefaultLog',

@type='REG_SZ',

@value='D:SQL2008Log'

修改用户库备份文件默认路径：

EXEC master..xp_regwrite

@rootkey='HKEY_LOCAL_MACHINE',

@key='SoftwareMicrosoftMicrosoft SQL ServerMSSQL10.SQL2008MSSQLServer',

@value_name='BackupDirectory',

@type='REG_SZ',

@value='D:SQL2008DBBak'