第2章SQL Server introduction.pptVIP

SQL SERVER DATABASE SYSTEM SQL Server introduction What is SQL Server ? Microsofts first DBMS which is used in windows application for commercial purposes. Rich in data manipulation tools, security features and very good documentations. Thus it is a leading DBMS used in commercial world by people who’s got money and wants to spend it. Several Version of it… SQL Server 6.5 SQL Server 7.0 SQL Server 2000 SQL Server 2005 And each having many editions. Our focus : SQL Server 2000 SQL Server 2000 Edition Enterprise Standard Personal Developer Components English Query Analysis Services Books Online Installation Before You Begin Be sure the computer meets the system requirements. Back up your current installation. Review all SQL Server installation options and be prepared to make the right selections Before You Begin Create one or more domain user accounts Shut down all services dependent on SQL Server. Such as any service using ODBC . Shut down Microsoft Event Viewer and registry viewers. Software Requirements Enterprise Edition (p23) Microsoft Windows NT Server 4.0 Microsoft Windows NT Server Enterprise Edition 4.0 Windows 2000 Server Windows 2000 Advanced Server Windows 2000 Data Center Server Windows 2003 Server Hardware requirements Hardware Minimum requirements Computer Intel or compatible Pentium 166 MHz or higher. Memory Enterprise Edition: 64 MB minimum, 128 MB or more recommended Personal Edition: 64 MB minimum on Windows 2000, 32 MB minimum on all other operating systems Hard disk space SQL Server database components: 95 to 270 MB, 250 MB typical Analysis Services: 50 MB minimum, 130 MB typical English Query: 80 MB Desktop Engine only: 44 MB Step 1:Installation Definition (p24) Installation Definition Client Tools Only Server and Client Tools