如何安装 SQL Server

60 0 0

打开SQL Server2008,在图形界面里修改数据库的存储路径：右击“对象资源管理器”，然后单击“属性”，在单击“数据库设置”，修改下面的“数据库默认位置”中的“数据”，“日志”里面的存储位置为你想放的位置即可。用SQL语句修改数据库的存储路径，将“E:YourData”，改为你想放的位置即可（这个我没试过，也是看大神写的，就总结在这里了）：查询用户库Data文件默认路径：DECLARE @DefaultData VARCHAR(100)EXEC master..xp_regread @rootkey=’HKEY_LOCAL_MACHINE’,@key=’SoftwareMicrosoftMicrosoft SQL ServerMSSQL.1MSSQLServer’,@value_name=’DefaultData’,@DefaultData=@DefaultData OUTPUTSELECT @DefaultData查询用户库Log文件默认路径：DECLARE @DefaultLog VARCHAR(100)EXEC master..xp_regread @rootkey=’HKEY_LOCAL_MACHINE’,@key=’SoftwareMicrosoftMicrosoft SQL ServerMSSQL.1MSSQLServer’,@value_name=’DefaultLog’,@DefaultLog=@DefaultLog OUTPUTSELECT @DefaultLog查询用户库备份文件默认路径：DECLARE @BackupDirectory VARCHAR(100)EXEC master..xp_regread @rootkey=’HKEY_LOCAL_MACHINE’,@key=’SoftwareMicrosoftMicrosoft SQL ServerMSSQL.1MSSQLServer’,@value_name=’BackupDirectory’,@BackupDirectory=@BackupDirectory OUTPUTSELECT @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’