系统数据库文件路径 master :program filesmicrosoft sql servermssql10.data master.mdf mastlog.ldf msdb :program filesmicrosoft sql servermssql10.data msdbdata.mdf msdblog.ldf model :program filesmicrosoft sql servermssql10.data model.mdf modellog.ldf tempdb :program filesmicrosoft sql servermssql10.data tempdb.mdf templog.ldf resource :program filesmicrosoft sql servermssql10.inn mssqlsystem-resource.mdf mssqlsystem-resource.ldf
SQL SERVER 版本路径
2008 :program filesmicrosoft sql server@ 2005 :program filesmicrosoft sql server90 2000 :program filesmicrosoft sql server80
安装/升级日志文件路径: :program filesmicrosoft sql server\100setup bootstraplogilessummary.txt 最近修改核心日志文件: :program filesmicrosoft sql server\100setup bootstraplogilessqlsetup[xxx]_[电脑名]_Core.log 最近修改windows 用户 接口文件: :program filesmicrosoft sql server\100setup bootstraplogilessqlsetup[xxxx]_[电脑名]_WI.log 组件安装文件:
:program filesmicrosoft sql server\100setup bootstraplogilessql setup[xxx]_{电脑名}_SQL.log
错误日志存放路径: :Program FilesMicrosoft SQL ServerMSSQL10.MSSQLLogERRORLOG
路径可以不用记,但是记住最好。 可以从【SQL Server配置管理器】→选择【SQL Server 服务】→【SQL Server(实例名)】→【属性】→【高级】→【启动参数】中获取,截图是SQL Server2012截图,和2008稍微有所不同,但是大概操作都是相同的:
|