SQLSERVER2005的安装目录结构（下） 上篇介绍了SQLSERVER在注册表里保存的一些设置，这篇介绍他在你的硬盘里存放了哪些组件和工具 带你进入SQLSERVER的世界 上篇的地址： 在 Microsoft SQL Server这个文件夹 里面有下面几个文件夹 逐个看一下每个文件夹里都
SQLSERVER2005的安装目录结构（下）
上篇介绍了SQLSERVER在注册表里保存的一些设置，这篇介绍他在你的硬盘里存放了哪些组件和工具
带你进入SQLSERVER的世界
上篇的地址：
在Microsoft SQL Server这个文件夹里面有下面几个文件夹
逐个看一下每个文件夹里都有些什么
-------------------------------------------------华丽的分割线----------------------------------------
首先80这个文件夹，位置C:\Program Files\Microsoft SQL Server\80
COM文件夹下有SQL2000的一些DLL，估计是沿用SQL2000的功能
在C:\Program Files\Microsoft SQL Server\80\Tools\binn这个目录有SQL2000数据转换服务工具DTSRun
------------------------------------------------华丽的分割线------------------------------------------------------
90这个文件夹，位置：C:\Program Files\Microsoft SQL Server\90
90这个文件夹里的东西多些，毕竟SQL2005比SQL2000功能已经强大了许多
在COM这个文件夹下，有tablediff这个比较有名的表格比较工具，这些工具比SQL2000的丰富多了
DTS目录下的工具都是为数据转换功能而写的，包括一些Oracle转换到SQLSERVER的组件
SQLSERVER导入/导出向导也在这个目录下
在SDK这个文件夹下面，有开发SQLSERVER的一些功能的API，也有C++的头文件和库给你调用
EULA是一些服务协议的txt文档说明
C:\Program Files\Microsoft SQL Server\90\Shared
Shared文件夹下的一些公共组件和工具，记得每次打完补丁之后都会弹出这个“Vista环境下的SQLSRVER用户设置”
C:\Program Files\Microsoft SQL Server\90\Tools
Tools文件夹下就包括了SQLSRVER的大部分工具了
例如：bcp命令 ，SQLdiag诊断工具，sqlmonitor监控复制工具都在C:\Program Files\Microsoft SQL Server\90\Tools\Binn目录下
还有在C:\Program Files\Microsoft SQL Server\90\Tools\Publishing目录下有发布工具，不过刚才说100这个文件夹的时候已经说了
在C:\Program Files\Microsoft SQL Server\90\Tools\Templates\olap\2052目录下有一些OLAP的模版
进行OLAP分析的时候估计就是调用这个文件夹下的模版
还有SQL Trace的时候有一些默认的trace模版，这些默认模板应该就是调用C:\Program Files\Microsoft SQL Server\90\Tools\Profiler\Templates\Microsoft SQL Server\90这个目录下的
-----------------------------------------华丽的分割线--------------------------------------------------------------
重点说明一下C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap 这个目录！！！
Setup Bootstrap这个文件夹存放了SQLSERVER的安装程序和安装过程中的安装日志，非常重要
如果遇到安装不顺利的情况，首先需要查看的就是文件夹里的安装日志
如果你不小心卸载了SQLSERVER的某些组件，可以在这个文件夹里找到安装程序，重新安装你卸载组件
控制面板里的"添加/删除程序"也是调用 ARPWrapper程序来进行SQLSERVER的组件的卸载的
关于安装日志的说明，这里就不详细说了，因为之前我已经写过一篇了
地址：设置SQLSERVER的错误日志数量和查找SQLSERVER安装错误日志
联机丛书上引用的CHM文件
1033文件夹里的是英文版的，2052文件夹里是中文版的
在SQLSERVER安装过程中调用的安装组件也是在Setup Bootstrap这个文件夹里调用的
微软已经准备好SQLSERVER各个版本的安装完毕之后的提示文件，rtf格式的，根据你安装的版本来进行相应调用
其实微软开发的软件跟我们开发的软件都是一样的，都需要准备相应的文件来进行调用显示，美国空间，解耦，深入了解了SQLSERVER的文件目录结构之后
大家会觉得跟我们开发的软件的结构是差不多的，但是里面SQLSERVER里面的代码会比较先进，但是SQLSERVER软件的文件跟我们基本上都是
一样的。
问题： 为什麽Setup Bootstrap这个文件夹不放在MSSQL.1文件夹里？
因为如果你删除了数据库引擎，你想重装数据库，去哪里找这个安装程序呢？
所以Setup Bootstrap这个文件夹就没有放在MSSQL.1文件夹里，就算删除了数据库引擎，那么还可以在
Setup Bootstrap文件夹里找到setup.exe重新安装
----------------------------------------华丽的分割线------------------------------------------------------------
100这个文件夹下的东西少一些，因为我没有安装SQL2008，所以东西比较少
位置：C:\Program Files\Microsoft SQL Server\100
100这个文件夹没有什么好说的了，SDK这个文件夹都是一些开发SQLSERVER的一些功能的API
-------------------------------------------华丽的分割线-----------------------------------------------
开始说MSSQL.1 ,MSSQL.2 , MSSQL.3这三个文件夹了
MSSQL.1：SQLSERVER
MSSQL.2：SSAS
MSSQL.3：SQLExpress
MSSQL.4：SSRS
-------------------------------------------------华丽的分割线-------------------------------------------------
MSSQL.1
打开MSSQL.1，看到下面的文件夹，网站空间，有几个不用介绍都知道有什么用的了
在Install文件夹放置了一些安装脚本，当你误删除某些功能或者数据库，可以在里面找到这些脚本然后执行安装
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG
LOG文件夹里有ErrorLog，网站空间，跟踪日志，还有维护计划报告和记录，当你创建一个维护计划的时候，你没有指定维护计划报告和记录
存放的位置，那么这个维护计划报告和记录就默认存放在C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG这个位置
----------------------------------------------华丽的分割线--------------------------------------------------
MSSQL.2 是SSAS，由于本人接触SSAS比较少，所以不多说了
-----------------------------------------------华丽的分割线--------------------------------------------
MSSQL.4：SSRS
ReportManager是一个ASP.NET Web程序，管理整个ReportService报表系统的
里面包含了
ReportBuilder:创建SSRS的报表的软件
ReportViewer：查看报表的控件
要打开配置报表服务器配置，可以在配置管理器里的SSRS服务那里打开
生成ReportServer和ReportServerTempDB两个数据库的数据库生成脚本
--------------------------------------------------华丽的分割线---------------------------------------------
总结
要睡了，明天搞一下微信公众平台 希望大家能够看完，因为都是一些流水账，如果大家能够顺利看完的话
我相信大家对SQLSERVER一定有一个质的飞跃 o(∩_∩)o
如果大家有什么需要补充的，或者文章有不正确的，欢迎大家拍砖！！
Explain the ACID properties (Atomicity, Consistency, Isolation, Durability).Apr 16, 2025 am 12:20 AMACID attributes include atomicity, consistency, isolation and durability, and are the cornerstone of database design. 1. Atomicity ensures that the transaction is either completely successful or completely failed. 2. Consistency ensures that the database remains consistent before and after a transaction. 3. Isolation ensures that transactions do not interfere with each other. 4. Persistence ensures that data is permanently saved after transaction submission.
MySQL: Database Management System vs. Programming LanguageApr 16, 2025 am 12:19 AMMySQL is not only a database management system (DBMS) but also closely related to programming languages. 1) As a DBMS, MySQL is used to store, organize and retrieve data, and optimizing indexes can improve query performance. 2) Combining SQL with programming languages, embedded in Python, using ORM tools such as SQLAlchemy can simplify operations. 3) Performance optimization includes indexing, querying, caching, library and table division and transaction management.
MySQL: Managing Data with SQL CommandsApr 16, 2025 am 12:19 AMMySQL uses SQL commands to manage data. 1. Basic commands include SELECT, INSERT, UPDATE and DELETE. 2. Advanced usage involves JOIN, subquery and aggregate functions. 3. Common errors include syntax, logic and performance issues. 4. Optimization tips include using indexes, avoiding SELECT* and using LIMIT.
MySQL's Purpose: Storing and Managing Data EffectivelyApr 16, 2025 am 12:16 AMMySQL is an efficient relational database management system suitable for storing and managing data. Its advantages include high-performance queries, flexible transaction processing and rich data types. In practical applications, MySQL is often used in e-commerce platforms, social networks and content management systems, but attention should be paid to performance optimization, data security and scalability.
SQL and MySQL: Understanding the RelationshipApr 16, 2025 am 12:14 AMThe relationship between SQL and MySQL is the relationship between standard languages and specific implementations. 1.SQL is a standard language used to manage and operate relational databases, allowing data addition, deletion, modification and query. 2.MySQL is a specific database management system that uses SQL as its operating language and provides efficient data storage and management.
Explain the role of InnoDB redo logs and undo logs.Apr 15, 2025 am 12:16 AMInnoDB uses redologs and undologs to ensure data consistency and reliability. 1.redologs record data page modification to ensure crash recovery and transaction persistence. 2.undologs records the original data value and supports transaction rollback and MVCC.
What are the key metrics to look for in an EXPLAIN output (type, key, rows, Extra)?Apr 15, 2025 am 12:15 AMKey metrics for EXPLAIN commands include type, key, rows, and Extra. 1) The type reflects the access type of the query. The higher the value, the higher the efficiency, such as const is better than ALL. 2) The key displays the index used, and NULL indicates no index. 3) rows estimates the number of scanned rows, affecting query performance. 4) Extra provides additional information, such as Usingfilesort prompts that it needs to be optimized.
What is the Using temporary status in EXPLAIN and how to avoid it?Apr 15, 2025 am 12:14 AMUsingtemporary indicates that the need to create temporary tables in MySQL queries, which are commonly found in ORDERBY using DISTINCT, GROUPBY, or non-indexed columns. You can avoid the occurrence of indexes and rewrite queries and improve query performance. Specifically, when Usingtemporary appears in EXPLAIN output, it means that MySQL needs to create temporary tables to handle queries. This usually occurs when: 1) deduplication or grouping when using DISTINCT or GROUPBY; 2) sort when ORDERBY contains non-index columns; 3) use complex subquery or join operations. Optimization methods include: 1) ORDERBY and GROUPB
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Atom editor mac version download
The most popular open source editor
MinGW - Minimalist GNU for Windows
This project is in the process of being migrated to osdn.net/projects/mingw, you can continue to follow us there. MinGW: A native Windows port of the GNU Compiler Collection (GCC), freely distributable import libraries and header files for building native Windows applications; includes extensions to the MSVC runtime to support C99 functionality. All MinGW software can run on 64-bit Windows platforms.
EditPlus Chinese cracked version
Small size, syntax highlighting, does not support code prompt function
Dreamweaver Mac version
Visual web development tools
Notepad++7.3.1
Easy-to-use and free code editor
