Post-it notes: Chapter 2 – Installing SQL Server 2008

December 2, 2012

Flirting with the idea of taking exam [70-432: Microsoft SQL Server 2008, Implementation and Maintenance] I created loads of post-it notes based on the book: “The Real MCTS SQL Server 2008 Exam 70-432 Prep kit”.I’ve decided to re-visit these notes (before the stickiness wears off and I lose them) and transfer them onto this blog. This will ultimately be a great knowledge refresher and quick reference guide for me. Hopefully you’ll find them useful too. Thanks for reading.

SQL Server 2008 edition comparison

SQL Server components

  • DB, RS, AS, IS services
  • SSMS, BIDS, Config Manager, Profile, DB Tuning Advisor, Command Prompt
  • No surface area configuration tool – within server properties – facets

SQL Server Editions

  • 3 categories, Server (enterprise and standard), Specialized (developer, workgroup, web) and Free (express and compact)
  • Developer edition has all features of enterprise
  • Up to 50 instances on all editions however only 25 on cluster
  • Enterprise & developer supports max cpu’s other editions less (e.g. std = 4)
  • Standard edition has a 4 CPU limitation on 32 or 64bit. Key limitation to enterprise edition
  • Max memory is unlimited for all editions except express = 1GB and workgroup = 4GB
  • DB size unlimited for all, except free editions, limited to 4GB

Enterprise Edition Features

  • DB snapshots
  • Fast Recovery
  • Online Indexing
  • Online restore
  • Mirrored backups
  • Backup compression
  • Hot add memory and CPU
  • Transparent Data encryption and Auditing
  • Supports Oracle publishing in peer to peer replication

AS/RS/SSIS

  • Analysis Services – enterprise, developer and standard
  • SSIS, Enterprise Full, Standard most features, others only runtime/import+export
  • RS – all editions except free ones.

Upgrade tools, requirements and paths

  • SQL 2000/2005 – Best practice analyser
  • SQL 2008 – SQL upgrade advisor – generates xml report in users folder
  • Upgrade advisor requires .net v2 and installer 4.5
  • Upgrade requirements: SQL 2000 Sp4
  • Upgrade requirements: SQL 2005 and Win 2008 – then you need SP2
  • Upgrade requirements: SQL 2005, RTM is ok, if not as per above in Win2008
  • SQL 2000 or 2005 (32/64) – SQL 2008 32 or 64bit
  • SQL 2005 (IA64) – SQL 2008 IA64
  • Log file: summary.txt in prog files\mssql server\100\setup bootstrap\log\files\

Hardware

  •  SQL 2008 supports x32, x64 and IA64
  • X32: Pentium III
  • IA64: Itanium (enterprise and developer only)
  • X64: AMD Opetron/Athlon 64, Intel Pentium IV, Intel Xeon
  • 64bit benefits – user more memory, large floating point and up to 64 processors
  • WOW64 – 64bit edition features which allows app to run in 32bit mode

Software

  • .NET 3.5
  • MS Installer 4.5
  • PS 1.0
  • IE v6 SP1 (for SSMS, BIDS, RS, HTLP Help and MMC)

Service Accounts

  • Domain user account: Normal option. Can access resources on network
  • Local user account: If not part of domain, this is a good option
  • Local service account: Not supported for SQL or AS. Same access as users group
  • Network service account: more access than users group, access network using computer acc
  • Local system account: very high privileges

Specifics

  • Version map 100 = SQL 2008; map 90 = SQL 2005; map 80 = SQL 2000
  • Resource database is hidden, used only to provide read-only version of sys objects
  • Extensions, mdf, ndf and ldf
  • Instance names cannot start with (- # $)
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: