以下仅为参照,如果有多个实例,可能会有些许不同: 本环境是SQL Server 2005 Standard Version 64-bit 和 SQL Server 2008 Standard Version 64-bit 双实例同时安装在一个 Windows Server 2008 Standard Version 64-
以下仅为参照,如果有多个实例,可能会有些许不同: 本环境是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' 复制代码 代码如下: 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'